With Excel dates in A1 and B1 (note: not text items that look like
dates), try this in C1:

=IF(A1B1,"A1 after B1",IF(B1A1,"A1 before B1","same dates"))

Hope this helps.

Pete

On May 3, 4:43 pm, wiggledg
wrote:
In Excel, how can I create an IF statement to return a value or text IF a
DATE is after or before another date? It doesn't seem to recognize dates and
is returning all the same value in the current IF statement I've created.
I'm not sure if it has something to do with formatting but I've changed the
formats to Dates, General, Text, etc and the IF statement still doesn't
work........