Date function

 arieta -
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!


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.

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!