Date functionClosed

Question

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


Configuration: Windows 7 / Mozilla 11.0

ac3mark · Answer

Can you just add another column for that?  Sounds like a real simple fix!

RayH · Answer

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))

Date function

2 replies

Subscribe To Our Newsletter!