Forum Discussion
Date problems in Excel 365 (1900s Dates). Each time I enter a 2020, 2019, 2018, or 2017
Dear all, I was working without any problems until recently I created a new worksheet and no matter what formatting I use the dates come out to be something in the 1900s. I have gone into the "Advanced" options and changed from 1900 to 1904 but it does not solve my problem. I need help! I am using the latest version of Microsoft 365, and Windows 10 as my OS. Have never had this issue before!
George.
4 Replies
Could you please be more specific, what exactly do you enter and which result receive.
For example, I am entering transactions for 2020 and I would enter 010120 (in day, month, year format but the value returned becomes "September 15, 1927."
Dates in Excel are sequential integer numbers starting from 1 which is assigned to Jan 01, 1900 (for Windows). Thus if you enter number 10120 that will be Sep 15, 1927 and number 44020 is for Jul 08, 2020. On Mac is the same story, but start is shifted on 4 years.
Depends on your regional format you shall enter dates in this format, like 01/01/20.
