Here is a New year gift to all our readers – free 2016 Excel Calendar & daily planner Template.
This calendar has,
- One page full calendar with notes, in 4 different color schemes
- Daily event planner & tracker
- 1 Mini calendar
- Monthly calendar (prints to 12 pages)
- Works for any year, just change year in Full tab.
See more snapshots here: 2016 Calendar template snapshot 1, snapshot 2 & snapshot 3
Download 2016 Calendar – Excel File
Click below links to download the calendar you want:
- 2016 Calendar & Daily Planner Template [Works in Excel 2016, 2013, 2010, 2007 & Mac Excel 2014, 2011]
- 2016 Calendar Template – Week starting on Monday [same as above]
- 2016 Calendar Template [Excel 2003]
How does this Calendar work?
This uses same techniques as mentioned in previous calendars. So check out this page to learn.
Go ahead and enjoy the download. The file is unlocked. So poke around the formulas and named ranges. Learn some Excel.
More Calendar Downloads:
Download these additional calendar templates and start your new year in awesome fashion!
2015 Calendar, 2014 Calendar, 2013 Calendar, 2012 Calendar, 2011 Calendar.
Other calendars & planners for you:
- Monthly Planner Template
- Event / Conference Agenda Template
- New Year Resolution Tracker
- Picture Calendar Template
- Todo list template
Techniques used in the calendar template: INDEX | OFFSET| INDIRECT | Array Formulas | Using Date & Time in Excel | Conditional Formatting
16 Responses
Really nice, thanks
Hi, Why would people go through all this for a calendar when OUTLOOK does it for you. Pointless exercise in 2016
Because they can?
Hi Eric… You are welcome to use it as you see fit. Many Excel applications / dashboards and reports involve some sort of calendar based analysis & reporting. I see such calendars playing a role in these scenarios. While Outlook / other apps provide calendar, how would you integrate them in to Excel if you want to make calendar / timeline a part of your report?
Hi & Happy New Year Chandoo,
You say “Works in Excel 2016, 2013, 2010, 2007 & Mac Excel 2014, 2011”.
So does it work in Excel 2016 for Mac? If not what part doesn’t work only I’m thinking of buying xl 2016 for my Mac as I only have xl on my old laptop with xl 2007.
Can I ask you kindly whether you have a weekly calendar or give me instructions as how to adapt one of your calendar templates
Thanks
Thanks for this fun, amazing creative calendar, good job friends.
Thanks Chandoo. I love your calendars. I can copy one into a file at anytime. I do want to know how to make the ‘Notes’ display on the ‘Monthly’ for the day entered. That would be most helpful for me, please.
Thank you for this creative calendar.
Do you have template calendar for 2017 yet
@Kerry
Download the 2016 File
Save it as 2017
Open the file
Goto the Full worksheet
Select the 2016 at the top
type 2017
Save &
Enjoy
Easy when you know how !
Thank you very much .
Just checking site for 2017 version. I’ll change date as above and I’m good. This is a really neat excel calendar to learn from and use. Over the years some great modifications have been added. thanks again who knows I’ll check back next month and perhaps will get new addition or tweak to study.
@Alan
All the Calendars from 2009 to 16 are driven from a single cell
Download any and change the source cell to 1/1/2017