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

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
+21
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"))
NHF-
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")))
+10
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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.