Forum Discussion
Solved
Using Calendar Creator (any year) template always returns 1905 as year
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 dat...
- If it works, then you may have an opportunity to choose your best answer:))
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.
- Thank you for that explanation. It makes sense, but I couldnt figure out what integer to use for 2022, luckily the comment above worked so I don't have to figure that out!
