3 ms·
Just don't try to use dates before January 1, 1900 (or 1904 on Mac). You can work with dates in Excel 1,000 years in the future, but if you try to do that for d
by whyenot 7y ago
Just don't try to use dates before January 1, 1900 (or 1904 on Mac). You can work with dates in Excel 1,000 years in the future, but if you try to do that for dates from the 1800s it will completely screw them up. I don't understand why this problem still exists today. If you work in a museum, or anywhere else where you deal with old dates, you have to constantly be on the lookout for this "gotcha."
- piokoch 7y agoThis is not directly related to issues you see, but might shed some light: https://www.joelonsoftware.com/2006/06/16/my-first-billg-review/ https://www.joelonsoftware.com/2006/06/16/my-first-billg-rev... (plus this is one of the funnies Joel Spolsky's text and an amazing dive into computers history).
- whyenot 7y agoThank you for sharing that, it's pretty interesting. I wouldn't have guessed that it was to maintain compatibility with Lotus 1-2-3.
- ubermonkey 7y agoI've read that piece before, but it's always worth reading again.