Forum Discussion
Dates incorrect
Hi, When I type in 01012017 into a column with a short date format of dd/mm/yyyy, I get 22/10/4674 and if I type in 01022017, I get 10/03/4702 - I have changed the format of the date and each forma...
The number you type is taken to be the number of days since the beginning of the year 1900.
Hence, 1022017 (days) is roughly 2804 years. Add the base value of 1900 and you find yourself in the year 4704. Enjoy it while it lasts :-)