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

Mel - Mar 4, 2010 at 08:46 PM - Latest reply: TrowaD 2377 Posts Sunday September 12, 2010Registration dateContributorStatus June 28, 2018 Last seen
- Nov 2, 2010 at 11:06 AM
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 

3 replies

Best answer
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Mar 5, 2010 at 03:47 AM
17
Thank you
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"))

Thank you, rizvisa1 17

Something to say? Add comment

CCM has helped 1807 users 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")))
TrowaD 2377 Posts Sunday September 12, 2010Registration dateContributorStatus June 28, 2018 Last seen - Nov 2, 2010 at 11:06 AM
10
Thank you
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