Here is a 2010 new year gift to all our readers – a free 2010 calendar template.
(a little secret: just change the year in “outline” sheet from 2010 to 2011, to get the next years calendar. It works all the way up to year 9999)
You can add notes to individual dates or complete month using the excel template very easily. There are 14 sheets,
- The first one called as “outline” calendar (also shown below) shows the calendar for entire year.
- The next 12 sheets show the monthly calendars from January thru December. Each month’s calendar also includes a snapshot (uses camera tool) of the previous and next month’s calendar. You can also add up to 6 notes per each date in the calendar. This is a good way to mark holidays, vacations and other important dates in the calendar.
- The last sheet shows a mini calendar – a compact yearly calendar for the year 2010 (or any other year specified in the Outline sheet). This is a good way to print a small calendar for your pocket or desk.
Download the 2010 Calendar
Download the Printable 2010 Calendar – in PDF format
How the calendar works?
Just in case you are curious to know how the formula magic works.. read on.
- To generate a calendar, we need to know the year. Lets say the year is in cell A1.
- Now, for each of the 12 months – Jan thru Dec, we need to know what is the “first weekday” and “how many days” are there in that month.
- This is very simple to find, we can use formulas like
- Now, make a grid of 6 rows by 7 columns – something like this –
- Show blanks until we reach the first date’s weekday.
- Start showing numbers in increasing order.
- Once you reach the number of days in that month, show blanks again.
- Repeat this process for all the 12 months. Neatly arrange the grids so they look like a calendar.
- That is all!
Go ahead and download the free calendar template. The file is unlocked. So poke around the formulas and see how it works.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Use CTRL+F1 to collapse ribbon [super-mini-quick-tip]||How to hide “0” in chart axis [quick tip] »|