Forum Discussion
Sbnl38
Apr 01, 2021Copper Contributor
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.
Sbnl38
Apr 14, 2021Copper Contributor
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
SergeiBaklan
Apr 14, 2021Diamond Contributor
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.