Excel Calendar that updates when inputting the year

[Sharr76]

Hi all,

I am trying to find or create an excel calendar that would automatically update the dates/days when you input the year. I am not an excel guru at all so this needs to be very basic and easy for me to do, if that's possible. Your help would be greatly appreciated.

[Keebellah]

If you search Google you will find a large number of Calendar addins and code that do just this, why invent the wheel again?

[Sharr76]

I am looking for one that I can use as a holiday calendar, to add information into it...I have searched on the Internet and I cant find one......this is the reason why I am asking for help in here.....

[Keebellah]

That was not your question
Correct information gives related answers.
In Excel, there are template files for just that.
The one I modified for my needs came from this site and it works
https://www.vertex42.com/calendars/2017.html