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