Hello,
I developed an application that has a task of reading an Excel file. Among the read data are dates.
When a cell in Excel has a date format it is actually returned as a number, for example, if I have a cell with the date "10th may 2021", when reading that sheet, number 44,326 is actually returned.
By reading some pages in Internet, they say that number is the number of days since 1st january 1900. However, if I add 44,326 days to 1st january 1900, the resulting date is 12th may 2021, which is 2 days later the right date.
To solve the problem, I am subtracting 2 days to the result, but this seems to be a trick instead of doing the right thing.
Can anybody explain me why I should subtract 2 days to get the right result? According to docs, the right number of days returned by Excel should be 44,324.
Thanks
Jaime
