You could use DATEVALUE("1/1/2007") instead of one of the cell
references to hardcode a date in the formula and to allow it to be
understood more easily, but isn't it easier to refer to a cell that
contains the date?

Hope this helps.

Pete

On May 3, 10:26 pm, wiggledg
wrote:
Thanks, I'm not sure why a date can't be hard coded into the formula, but it
works now that I have the formula targeted to a cell. Thanks again!!!



"Pete_UK" wrote:
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........- Hide quoted text -

- Show quoted text -