YearPlannerScreenShot

Excel Year Planner and Perpetual Calendar

Online calendars are all well and good, but sometimes you need something people can print off and stick to the wall next to their desk. So here’s an Excel-based Year Planner, which you can customise to your requirements:

YearPlannerScreenShot

Download Customisable Excel Year Planner

(2015 PDF Version //  2015 PNG Version )

Notes

  1. Excel 2010 format (.xlsx)
  2. This will work with older version of Excel as long as you enable the Microsoft Excel Analysis Toolpack Add-In, which provides the WEEKDAY() function.
  3. Change the date in cel A42, and the calendar will redraw. Default is an Annual Calendar running Jan -> Dec
  4. I’ve switched to a Blue/Green colour scheme, from the red/orange scheme in the screenshot. I find it calming. Colours are customisable. There are some cells with hidden text (formatted ;;; if you’re an excel fan) that will not be printed out (even on mono printers, yay!). If you find any I missed, let me know.
  5. The Calendar description is editable (default: Year Planner)
  6. The print area is sized for European ISO 216 A-series but is still fine on Legal/Executive ratios [margins a little bit thin].
  7. Having pondered week numbers, I’ve structured the sheet so that they will always be ISO 8601 compliant. Yes, sometimes years do have 53 weeks; that’s ISO standards for you. The prefix for the Week numbers (default “WK”) is stored in cell A2.
  8. There’s space above the sheet for your branding or information.
  9. Feel free to put your own branding on the sheet, but please do not remove the Creative Commons licensing information (Cell BK1) and logo.

2 thoughts on “Excel Year Planner and Perpetual Calendar”

  1. Hi James, thank you for the template – its great! I was just wondering, when I print it out, I can see the minus numbers in the grey cells – any idea how to get rid of it?

  2. This template is very useful, thank you, James.
    I like to make some modifications in the the cells C5/C8/C11/ec. to structure the day with 3 horizontal cells for morning/afternoon/evening.
    I’m not used to excel. How can I do it?
    Thank you for your reply.
    Kind regards from Zurich
    Sabina

Leave a Reply