Dec 08 2021 11:04 AM
Hi,
I am trying to create a 2022, 12 month calendar, using the Calender Creator template in Excel. It says that I should be able to type "=Year(2022) and the template should autopopulate the dates for you. Well, it changes 2022 to 1905 and populates the incorrect dates. What am I doing wrong?
Dec 08 2021 11:12 AM
@CourtnyN You should enter just simply 2022.
No function, I hope... Try it, please
Dec 08 2021 12:11 PM
In addition to @Ilgar_Zarbaliyev response. Dates in Excel are sequential integer numbers starting from 1 which is consider as 01 January 1900. Date format is only to make such numbers more human friendly.
Thus if you enter number 2022 and apply date format to this cell, you will see 14 July 1905. YEAR() function applied to that date obviously returns 1905.
Dec 08 2021 01:28 PM
Dec 08 2021 01:29 PM
Dec 08 2021 02:06 PM
SolutionDec 08 2021 03:08 PM
Dec 08 2021 02:06 PM
Solution