Date function

Closed
a2 - Mar 8, 2016 at 01:29 PM
 arieta - Mar 9, 2016 at 03:17 PM
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

Blocked Profile
Mar 8, 2016 at 03:41 PM
Can you just add another column for that? Sounds like a real simple fix!
0
thank you AC3Mark. much appreciated
0
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))
0
Hi Ray
thank you very much to you too for responding. appreciate the time
0