Cool Excel Year Planner now available for download

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

A clever and different year planner is now available for download as an Excel workbook.

The days remaining in the year are visible with weekends shaded and each day of week shown.

cool excel year planner now available for download microsoft office 36551 - Cool Excel Year Planner now available for download

At the bottom is a clever use of Excel’s Chart features to make a progress ‘thermometer’ for the year.

Even if you don’t need a year planner, download and check out the worksheet to see how the ‘Big Girls and Boys’ do it.

The ‘Big Boy’ in this case is Office Watch friend ‘Jeff B.’ – Thanks Jeff!

Thermometer ‘chart’ in Excel

The percentage progress begins by calculating how much of the year has passed.  It’s not a simple formula on the Data tab, B20

cool excel year planner now available for download microsoft office 36552 - Cool Excel Year Planner now available for download

From there, finding the remainder of the year Data!B21 is simple.

The chart is created from the formula =SERIES(,,Data!$B$20,1) and =SERIES(,,Data!$B$20,1). It’s actually two Stacked Bar charts next to each other.

cool excel year planner now available for download microsoft office 36553 - Cool Excel Year Planner now available for download

A fussy way to do it but Microsoft, for some reason, hasn’t provided a simple in-built chart for such an obvious use.

Pull down years

Choose the year from the pull-down in A1, right-click and choose ‘Format Control

cool excel year planner now available for download microsoft office 36554 - Cool Excel Year Planner now available for download

Instead of making a pull-down the usual way, Jeff made a control which gives more control (no pun intended) like number of drop-down lines and 3D shading.

How to download

Download the Year Planner workbook here.

Right-click on the link and choose ‘Save link as …’ or ‘Save Target As ..’ depending on your browser.

It’s a standard .xlsx Excel workbook that works in Excel 2007 and later.

The inevitable disclaimer: We’ve checked and rechecked the download for viruses and other nasties. However, you should never take anyone’s word for that and check for yourself.  Windows Defender will automatically check for you.  Don’t run with scissors. Call your mother.

Academic / Financial year planner for Excel

Yearly Planner / Calendar for Office Watch readers

Simple text with day, month and year to Excel date conversion

Making Yearly calendars and more from Word

Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address