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
|