Forum Discussion
joan1994
Aug 17, 2025Copper Contributor
Help to automatically have 2025 as year in excel, Date System
Microsoft 365, Windows 11, I used "1904 Date System" and the years starts at 2002. I unchecked the "1904 Date System" and the years starts at 2007. I see no option beside "1904 Date System" for "19...
HansVogelaar
Aug 18, 2025MVP
If you originally had '1904 Date System' checked, then clear it, the active workbook will automatically use the '1900 Date System'. There are no other systems apart from those two. All existing dates in the active workbook will shift 4 years and 1 day backwards. For example, August 18, 2025 will become August 17, 2021. Dates in other workbooks will not be affected.
When you enter only a month and day, Excel will always assume the current year. But if you check or clear the '1904 Date System' check box after that, the date will change.