Forum Discussion
Year keeps on changing in date when I open an excel worksheet that was emailed
When I open the excel worksheet that was emailed the year on the date changes from 2021 to 2025.
If that's Windows machine you may change this setting for the workbook
Not sure about Excel on Mac.
Spreadsheet has different worksheet/tabs on it. When I untick 1904 date system, other date changes to 2017 and adds one day and year changes to 2025 in the date on other sheets, a
Sorry, I didn't catch waht is the question. Yes, if you change the basis for datetime calculations all already entered dates will be changed since you have new basis.