Forum Discussion
Bug In Microsoft Excel? - Dates on Workheet Changed
Hello, I have a customer that I have worked with for over two years. My contact at the customer's site and I started to work through the company's workbook at the beginning of this month to grab ...
You probably switched to 1904 date system.
I found that solution later, thanks. Just updated it here because the initial message was pretty old.
Strangely enough the solution changes the date also with a day in some cases. Will play around with that some more.
However, I think this is really some kind of bug, because the changes from '23 to '27 and '24 to '28 appear with stable data within the same sheet. But over multiple sheets in one workbook. With stable I mean not during copying, but the change happens halfway through a row of dates that have been there for some time. But not all of them - the last '24 dates have remained correct.
It also didn't seem to have affected older dates prior to '23 in other sheets. or '23 and '24 dates in other workbooks, just a few.
Strangely enough the solution changes the date also with a day in some cases. Will play around with that some more.
However, I think this is really some kind of bug, because the changes from '23 to '27 and '24 to '28 appear with stable data within the same sheet. But over multiple sheets in one workbook. With stable I mean not during copying, but the change happens halfway through a row of dates that have been there for some time. But not all of them - the last '24 dates have remained correct.
It also didn't seem to have affected older dates prior to '23 in other sheets. or '23 and '24 dates in other workbooks, just a few.