• Subject: Re: Serial Date formula
  • From: Douglas Handy <dhandy1@xxxxxxxxxxxxx>
  • Date: Fri, 13 Apr 2001 11:19:37 -0400

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
+---

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].