May 29 2018 08:25 AM
1900 was not a leap year due to a special century rule in the Gregorian calendar, but Excel is not handling this rule correctly, causing issues when calculating dates as well as when converting spreadsheets using Microsoft.Office.Interop.Excel. Dates prior to 3/1/1900 are off by one day. Meanwhile MS SQL Server does handle these date rules correctly, as illustrated below:
May 29 2018 08:27 AM
May 29 2018 08:42 AM
SolutionHi John,
That's known issue, please see https://support.microsoft.com/en-us/help/214326/excel-incorrectly-assumes-that-the-year-1900-is-a-le...
May 29 2018 08:42 AM
SolutionHi John,
That's known issue, please see https://support.microsoft.com/en-us/help/214326/excel-incorrectly-assumes-that-the-year-1900-is-a-le...