Posted by Jim Guerber (66.180.141.206) on November 08, 2003 at 00:50:37:
In Reply to: NUM2DATE posted by Jon Sacks on November 07, 2003 at 11:21:44:
Oh, OK, let me look here in my pocket of "Hidden" features.................
Oh Yeah, here is one we documented in that comet 2004 document...
"The NUM2DATE function contains a new option that returns the local date and time with the hour adjustment for time zone and daylight savings time appended. The NUM2DATE option is 5, as in A$=NUM2DATE(date-serial-number,5). The function returns the date/time in the following format:
Day, DD Mon YYYY HH:MM:SS -nnnn –mmmm
Where -nnnn is the number or hours + or – different from Greenwich Mean Time (GMT), and –mmmm is the daylight savings time adjustment."