Date issue

[Guest]

Writing a function in Excel 2003 that starts"=IF(<11/30/2006..."
When run the function returns a false result, however if the date is entered
as "=IF(<39093", the "serial date" that Excel uses it returns a correct
result. Shouldn't the function be using the "human friendly" date format?
What do I need to do to correct this, as I can't expect the teacher to figure
out "serial dates"?

THANKS

 

[Peo Sjoblom]

Try

=IF(A2<--"11/30/2006"

or better

=IF(A2<--"2006-11-30"

or even better

=IF(A2<DATE(2006,11,30)

 

[Ron de Bruin]

The ISO date format in the string Peo use is working in all Excel language versions and
is always interpreted correctly as a date.

There is more info here if you want to know more
http://www.rondebruin.nl/isodate.htm

 

[Harlan Grove]

The ISO date format in the string Peo use is working in all Excel language
versions and is always interpreted correctly as a date.

....

Very picky: with transition formula entry, the entry 2007-07-27 is
interpreted as =2007-7-27 and returns 1973; transition formula evaluation
treats --"2007-07-27" as 0.