Perpetual Calendar (Advanced)

$4.99

The Calendar (Advanced) template is a perpetual yearly calendar that allows you to enter the year, public holidays, special days and a choice of 3 colour schemes. It has two yearly calendars – one in landscape and the other in portrait format, and monthly calendars for January to December. It has more features than the Calendar (Basic) template.

Category: Tag:

The Calendar (Advanced) template allows you to enter the following inputs:

  • Year
  • Day To Start the Week with (e.g. Sunday, Monday or other days)
  • Labels for each Day of the Week (e.g. Su, M, Tu, W, etc)
  • Public Holidays (name, day, month) [Up to 18 holidays]
  • Special Days such as birthdays (name, day, month) [Up to 10 special days]
  • Choose from 3 colour schemes (blue, red and green)

With these inputs, it will automatically generate:

  • Full-Year Calendar (in Portrait), with the public holidays listed and highlighted
  • Full-Year Calendar (in Landscape), with the public holidays listed and highlighted
  • Monthly Calendars (from January to December), with public holidays and special days listed and highlighted, spaces for typing into the calendar in each day and previous/next month mini-calendars

Features in bold are the additional features not found in the Calendar (Basic).

Check out the pictures to see what you can generate!

NOTE: This Excel template is protected and locked, so only the input cells in purple, and some cells in the monthly calendar can be edited. It works only for Excel 2007 or later versions of Excel. No macros are used.