If date in cell is greater than date in cell [Solved/Closed]

Report
-
Posts
2731
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 22, 2021
-
Hello,

I am a beginner with formulas in Excel. I am working with dates formatted dd/mm/yyyy. I need a formula that will return a value of yes or no, if the date in cell A1 is before or after the date in cell B1.

Can someone help.

Thanks,
Mel
Related:

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
Use IF statement

'yes if date 1 is not equal to day 2
=IF(A1<>B1, "YES", "NO")

'to show you use of nested if
=IF(A1>B1, "YES, A1>B1, IF(A1=B1, "YES, A1=B1, "Default A1 < B1"))
19
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

I am using the formula to determine which deposit dates were late vs timely, and it is not calculating correctly. Can you help me determine why? Everything except for a blank E8 comes out "late".

=IF(E8>M8,"LATE",IF(E8=M8,"TIMELY",IF(E8<M8,"TIMELY")))
Posts
2731
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 22, 2021
459
Hi NHF,

There doesn't seem to be anything wrong with your formula.
I would advise you to look at the cell properties (Ctrl+1) and make sure they are the same.

Your formula is unneedly long though.
Since you are basically saying if E8>M8 then "Late", anything else (either = or <) "Timely". the formula:
=IF(E8>M8,"LATE","TIMELY")
would be enough.

If you are still having problem then it might be an idea to post your workbook using www.speedyshare.com.

Good luck and best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!