Forum Discussion
myers2020
Apr 23, 2019Copper Contributor
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...
SergeiBaklan
Apr 23, 2019Diamond Contributor
Dates in Excel are actually integers numbers starting from 1 which is Jan 01, 1900. Thus, for example, Apr 23, 2019 is equal to 43578. When you enter much larger number you receive the far away date.
Formatting is only to make date more human friendly to operate, they are integer numbers.