Report

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

Ask a question Mel - Last answered on Nov 2, 2010 11:06AM by TrowaD
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
See more 
Helpful
+21
moins plus
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- Nov 1, 2010 12:04PM
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")))
Reply
Leave a comment
Helpful
+10
moins plus
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
Leave a comment

Member requests are more likely to be responded to.

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

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!