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 third quarter earnings and other related data for an upcoming meeting. We realized that on two of the main worksheets all of the dates have defaulted to the first of the month. The months and years are correct but the days have been all changed to the first. She and I are the only ones that work on and have access to the workbook and it lives on her machine (I remote in when needed). I have tried to debug by taking the worksheets and moving them into their own workbook - the dates come back to normal. The only thing I can think of is that we have something in the pivot tables, but I thought that was a one way street meaning the pivot table pulls from the worksheet - it cannot make changes to the worksheet. Any ideas greatly appreciated (PS we are both on PC and she is using Excel 2022. Thanks in advance for the thoughts!
4 Replies
loriesoliwoda I have the same problem. On some of my sheets the 2023 date has been changed to 2027 and 2024 to 2028. Unfortunately it's very difficult for me to check whether it's only the year that has been changed, or the whole date...
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.
PS... while checking through the different data types yet again, now the bug has been able to change our year such that randomly our 2023 years are now 2025, 2026, and 2027
