Solved Is date in cell D2 older than 90 days?

December 21, 2016 at 11:47:28
Specs: Windows 7
in cell H2 I'm entering this to get a yes or no answer, if the date in cell D2 is past 90 days.
=IF(D2-TODAY()>90, "No", IF(TODAY()-D2>90, "Yes", ""))
It's not working

See More: Is date in cell D2 older than 90 days?

Report •

#1
December 21, 2016 at 12:08:29
✔ Best Answer
If you want a Yes if the date is older than 90 days, then use this:

=IF(TODAY()-D2>90, "Yes", "No")

The syntax of the IF function is:

=IF (logical_test, [value_if_true], [value_if_false])

For a simple IF, you only need one logical_test and "answers" for when the result is True and False. In other words, you don't have to check the Date twice like you were doing.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
December 21, 2016 at 12:16:47
This works great! Is there any way to leave the results blank if there is not a date in the cell?

Report •

#3
December 21, 2016 at 12:31:18
Now we are into what is known as a Nested IF.

Basically, the value_if_false argument is another IF function.

=IF(D2="", "", IF(TODAY()-D2>90, "Yes", "No"))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
December 21, 2016 at 12:40:37
This is perfect. Thanks for your help!

Report •

#5
January 2, 2017 at 16:39:29
DD03 is da bomb. :)

Doing the best I can here... And remember, there's always more than one path to success. :)


Report •

#6
January 3, 2017 at 03:47:42
Thanks and Happy New Year!

Keep up your good work too!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question