Possible culprit: in Microsoft Excel a zero in a cell marked as being a date is treated as midnight 30 December 1899. Why midnight on Dec 30th rather than Dec 31st or Jan 1st? To work around a bug in Lotus. See ericlippert.com/2003/09/16/e... for details.
I find software horology fascinating. The other day, Raymond said “The OLE automation date format is a floating point value, counting days since midnight 30 December 1899. Hours and minutes a…
