Perpetual Calendar from Vertex42 is an Excel spreadsheet that creates calendars for any year from 1900 to 9999, beginning with any month you like, holidays included. It's extremely easy to use: Simply enter the year, tweak any fields, and click Save or Print. It behaves like any Excel template.
Perpetual Calendar downloads as a compressed file but opens normally in Excel when extracted. The spreadsheet is clearly configured, with a large year display above a 12-month calendar. To the right is a list titled Events or Holidays; it included not only traditional holidays but also tax day and equinoxes and solstices. Fields titled Year, Month, and Start Date let us change the year and set when our calendar should start, which is great for tracking projects and other fixed time periods. Another field let us create a custom title. We typed in 2012 in the date field and received 2012's calendar, then we typed in 2112: So far, so good. We entered 3112 and sure enough, the spreadsheet displayed January 3112, though we think compatibility issues would start to show up in the next millennium. How about 9999? Yes, it even creates calendars for 9999, though surely Microsoft will have released a substantial update to Excel by then. The spreadsheet gave it up by the year 10000, but it makes up for it by going back in time to 1900. Clicking the Web link on the interface took us to Vertex42's page, which offered documentation, screenshots, and more. However, this spreadsheet is extremely easy to use.
You need to have Microsoft Excel to run Perpetual Calendar, though Vertex42 offers an OpenOffice version, too. This is a great little calendar spreadsheet; just the thing for planning, recordkeeping, research, and staying organized.
Do you need an easy-to-use system for creating calendars? The free Perpetual Calendar by Vertex42.com is one of the most powerful and flexible calendar tools available, and all you need is Microsoft Excel. You can start the calendar with any month of the year, so if you start your plan mid-year or you need a convenient school calendar, this template will work well. In addition to letting you create printable yearly and monthly calendars, you can keep track of recurring yearly events such as birthdays, anniversaries and holidays. You can add these events to the "Year" worksheet and up to 3 events per day will automatically be added to the 12 individual monthly calendars (located on the 12 numbered worksheet tabs). If you use formulas like the examples provided, when you change the year the calendar will automatically include your events in the monthly calendars (that is why this calendar is "perpetual"). More information about how to use the Perpetual Calendar spreadsheet, such as how to add the event formulas or create a PDF, can be found on the official author page.