• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: excel dates
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: excel dates


  • Subject: Re: excel dates
  • From: Paul Hoadley <email@hidden>
  • Date: Tue, 29 Nov 2016 09:00:32 +1030

On 29 Nov 2016, at 8:38 AM, Theodore Petrosky <email@hidden> wrote:

Why does excel behave so badly. well the original website I found said that excel calculated dates fro 01/01/1900 but that was incorrect. it is really 01/00/1900, but there is more:

See also:

http://www.joelonsoftware.com/items/2006/06/16.html

And just for laughs, check out the section on "Problems with using dates in the range October 5, 1582, through October 14, 1582” here:

http://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_r0053436.html


-- 
Paul Hoadley
http://logicsquad.net/
https://www.linkedin.com/company/logic-squad/


 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

References: 
 >excel dates (From: Theodore Petrosky <email@hidden>)
 >Re: excel dates (From: Theodore Petrosky <email@hidden>)

  • Prev by Date: Re: excel dates
  • Next by Date: Re: excel dates
  • Previous by thread: Re: excel dates
  • Next by thread: Re: excel dates
  • Index(es):
    • Date
    • Thread