Date function

Question

Date function

[Closed]

Report

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

Date function
Functions of spreadsheet - Articles
Functionality of wifi - How-To - Connection
What is mutator function in c++ - How-To - C++ Language
Acer function keys not working - How-To - Office Software
Function key stuck on - How-To - Keyboard

2 replies

Ask a question

Blocked Profile · Answer 1 · 2016-03-08T15:41:44-0500

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!

Report

arieta
Mar 9, 2016 at 03:15 PM

thank you AC3Mark. much appreciated

RayH · Answer 2 · 2016-03-08T16:11:58-0500

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

Report

arieta
Mar 9, 2016 at 03:17 PM

Hi Ray
thank you very much to you too for responding. appreciate the time

Date function

2 replies

Your reply

Subscribe To Our Newsletter!