Date function

[Closed]
Report
-
 arieta -
Hello,
I'm using a function =date(year(j2)+(m2),month(j2),day(j2))

BUT.. I want to be able to type in words like NIL, NO, and DEFER in to cell M2 without affecting the final date.

can you help please? It gives me a #Value notification when I type in those words.

thank you!

a2


2 replies


Can you just add another column for that? Sounds like a real simple fix!
thank you AC3Mark. much appreciated
Or simply include an IF in the formula.


=DATE(YEAR(J2)+IF(OR(M2="NIL",M2="NO",M2="DEFER"),0,M2),MONTH(J2),DAY(J2))
Hi Ray
thank you very much to you too for responding. appreciate the time

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!