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 "Advan...
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.