Hi Monica,

Dates are always very sensitive to the way they are entered, different date
systems, etc.

Easiest is to enter both dates to compare with in a cell instead of using
literals.
Your formula would the be something like

=IF(A3A4,PAST","FUTURE")

By formatting the dates as mmm/dd/yyyy (noye the extra m) you can easily
check if the date system is what you expeceted it to be.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"MLD" wrote in message
...
I am usually a whix with IF statements, but this one has me stumped.
I have a user who wants this:

=IF(A36/28/2005,"PAST","FUTURE")

However, it seems that no matter what date we enter, it still shows all
dates as "PAST". I doubl;e checked the formatting of the date column
(where
the actual data is supposed to go) and made sure it was a basic date.

This seems so basic, why can't I fix it?

-Monica