SOLVED

Date calculation bug in Excel

Copper Contributor

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:

 

Excel Date Calculation Issue.JPG

2 Replies
I am running Excel 2013 (15.1.5031.1000) 32 bit
best response confirmed by John Dewey (Copper Contributor)
1 best response

Accepted Solutions
best response confirmed by John Dewey (Copper Contributor)