How to create a perpetual calendar (from 1900 to 9999)

Excel 2007
Excel 2003
Macros Excel 2007
Macros Excel 2003
Excel 2010
Home
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.
Download Link
You can read the details of how to create this template using this link.


Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010
Home