That should have been

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

--
Kind regards,

Niek Otten

Microsoft MVP - Excel


"Niek Otten" wrote in message
...
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