2019 Excel Year Planner

Around this time of year, folks may be looking for smart, customisable year planner charts for their desk or office.

Remember my planner can do academic style charts simply by changing the start month.

My old planner was last updated in 2013 and still works great - all you need to do is change the year in the Start tab.

Please do check it out if an Excel based year planner is what you are looking for.

Link here.

Thanks for looking!

Yearplanner V4.0 available

22 November 2017: Hi folks! Thanks to everyone who's downloaded and enjoyed my year planner macro over the years. I have had reports that the macro does not work under Office 2016 which until now I have not been able to test. As I write, the macro (V4.1) works unchanged on a new Office 365 install on a Mac. However if you have another workbook open it will fail with a 'Subscript out of range' error. I promise to fix this in the near future! So, close all other open workbooks and try again.

It's taken me a while to get around to updating it, but here it is, Yearplanner Maker V4.0!

This update streamlines the Control Panel dialog, but more importantly introduces a new feature: split years. So if you begin a chart in June, it'll run to May the following year.

I've included a security disclaimer/guide for those struggling to get it to run under Excels' default macro security settings (tip: you need to turn security off).

In addition, there's a few lines describing the basic use of the Control Panel.