Date issue
 

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

Date issue
 

Try

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

or better

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

or even better

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


--
Regards,

Peo Sjoblom





"Jim at SDSU" wrote in message
...
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

Date issue
 

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Peo Sjoblom" wrote in message ...
Try

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

or better

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

or even better

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


--
Regards,

Peo Sjoblom





"Jim at SDSU" wrote in message
...
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

Date issue
 

"Ron de Bruin" wrote...
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.