On Tue, 28 Jun 2005 16:04:47 -0400, "MLD" wrote:

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


6/28/2005 is not being interpreted as a date, but rather as 6 divided by 28
divided by 2005 or a very small number.

Try:

=IF(A3DATEVALUE("6/28/2005"),"PAST","FUTURE")

Or put your 6/28/2005 in some cell and reference that cell.


--ron