Re: Serial Date formula

[Douglas Handy <dhandy1@xxxxxxxxxxxxx>]

JT,

>Well, I'll be darned !  The Excel serial date for 1901-01-01 is 367.  The
>date for DATEVALUE(60) is 1900-02-29.
>
>Excel calculates the year 1900 to be a leap year which, as Leif pointed out,
>it isn't.

I remember lots of discussion in the Y2K prep/test days, when it was reported
the original forumula used by MS Excel on the Mac did in fact not have the
proper rules for leap years.  The original Mac programmer screwed up, and nobody
caught it at the time.  Or for quite awhile after that.

But the bigger problem was that spreadsheets stored the date as the offset, so
fixing the code could break existing spreadsheets. 

Leave it to MS to "excel" at features like this...

Doug
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---