On 10/02/2011 12:53 AM, Nick Burch wrote:
Microsoft got it wrong though - they think thought that there was a
29th of Feb 1900, but there wasn't... Take a look at
http://svn.apache.org/repos/asf/poi/trunk/src/java/org/apache/poi/ss/usermodel/DateUtil.java
for the gory details of how to do it. I think the extra day is an
inclusive/exclusive thing.
I believe they deliberately copied and error from Lotus 1-2-3 to make
Excel more compatible. I'm not sure if that is better or worse than
making the error in the first place.
I forgot where I got that from -- might have been one of the early
Stackoverflow podcasts.
Peter
