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

Ask a question Mel - Last answered on Nov 2, 2010 at 11:06 AM by TrowaD

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.

plus moins
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"))
Was this answer helpful?  
NHF- Nov 1, 2010 at 12:04 PM
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".

plus moins

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:
would be enough.

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

Good luck and best regards,

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!