- Formula - if date if less than today's date then equals yes
- Excel if formula, date is greater than another date highlight
- If function date less than another date
- Excel - Adding the current date in cell
- Excel - Add a fixed date in a cell
- Excel - Conditional Formatting or IF using Dates
- Create a date from 3 different cells [Solved] (Solved)
- Highlight one cell based on date in a range (Solved)

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"))

'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?

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

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.

A CCM membership gives you access to additional options.

NHF- Nov 1, 2010 at 12:04 PM=IF(E8>M8,"LATE",IF(E8=M8,"TIMELY",IF(E8<M8,"TIMELY")))