Previous Topic Next Topic

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


Related:

2 responses

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

Similar discussions

If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response
"Sorry, this feature isn't available ... " how to fix this?
Anonymous User -
heclam -

3 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to disable Fn keys
HENRY -
ZiaRahman -

30 responses