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:
- Excel 2010 format (.xlsx)
- 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.
- Change the date in cel A42, and the calendar will redraw. Default is an Annual Calendar running Jan -> Dec
- 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.
- The Calendar description is editable (default: Year Planner)
- The print area is sized for European ISO 216 A-series but is still fine on Legal/Executive ratios [margins a little bit thin].
- 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.
- There’s space above the sheet for your branding or information.
- Feel free to put your own branding on the sheet, but please do not remove the Creative Commons licensing information (Cell BK1) and logo.