Date issue

J

Jim at SDSU

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
 
P

Peo Sjoblom

Try

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

or better

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

or even better

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

Harlan Grove

Ron de Bruin said:
The ISO date format in the string Peo use is working in all Excel language
versions and is always interpreted correctly as a date.
Click to expand...
....

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.
 
Top