Thread: Date issue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim at SDSU Jim at SDSU is offline
external usenet poster
 
Posts: 7
Default 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