Dates in excel are strange creatures.
They are not like calendars, but rather than numbers.
The creators of excel came up with the brilliant idea of starting from somewhere in time, then count the number of days.
That day (day one) was decided to be 01/01/1900 – So if I write this date in excel, and copy it as value, I will get 1.
1,2,3… and so on so forth. This might be O.K. for days, but how do you count a half day?
Parts of the days are expressed in decimals. They can go down to as small unit as a second. That’s how dates in excel are expressed.
For example the date: 23/01/2020 09:00 as a value looks like this in excel: 43853.375000
Let’s break down this number:
The first part: 43853 means that It is the 43853th day since 01/01/1900.
The second part is a decimal expression of the 9 hour if 24 was 1.
Now to get you confused. There is another date system can be found in excel.
There is the one that starts at year 1900, and there is another one that starts at 1904.
It has to do something with the compatibility between Mac and windows. The old macintosh system uses a date system that starts in 1904.
How can I turn this 1904 system on?
You can do this in the options panel.
Time needed: 2 minutes.
- Go to file
- Go to Options
- Go to Advanced
- Then check option “Use 1904 date option”