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

=IF(A3>6/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