“Actually there is a known (and documented) bug with the Excel date function and it is off by two days, so this date 38106 translates to 5/1/04″
May 23, 2012 – Sometimes, when you copy a sheet to a new workbook, Excel changes the date. It isn’t abug; you’re dealing with two different date systems.
The year 1900 problem concerns the misinterpretation of years recorded by only their last two … Microsoft Excel cannot display dates before the year 1900, although this is not … This is for compatibility with Lotus 1-2-3 which also had this bug.
View original post 214 more words