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.