How to create a perpetual calendar (from 1900 to 9999)
I had to share this awesome perpetual calendar template in Microsoft Excel created by Diego Oppenheimer using simple named ranges and date functions. With this Excel calendar, you can use a scroll bar to quickly select a year from 1900 to 9999 and display the correct dates. You can customize the formatting and change the background easily to your taste and have a new calendar every year quickly and easily.
Calendar (any year)
How to Create a Perpetual Yearly Calendar in Excel