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
Download the 2010 Calendar Spreadsheet – Excel 2007+ | Excel 2003
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
=WEEKDAY(DATE(A1,1,1))and=DATE(A1,2,1)-DATE(A1,1,1) - 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.
3 Responses to “How-to create an elegant, fun & useful Excel Tracker – Step by Step Tutorial”
Hi Chandoo,
I am responsible for tracking when church reports are submitted on time or not and the variations from the due date for submission.
Here is the Scenario;
The due date for the submission of monthly reports is on the 5th of each month. and I would like to know how many reports have been submitted on time (i.e, those that have been submitted on or before the due date) I would also want to track those reports that have been submitted after the due date has passed.
How can I create such a tracker?
Hi Chandoo,
I am a member of your excel school.
I was trying to create SOP Tracker I follow all your steps but I keep this error below.
The list source must be a delimited list, or a reference to a single row or cell.
I try looking on YouTube for answer but no luck.
can you help on this?
thanks
Carl.
Dear Mr. Chando,
Rakesh, I'm working in a private company in the UAE. Recently, I'm struggling to get more details about the staff sick, annual, unpaid, and leaves. I would like to get a tracker in excel. Could you please help me in this situation?
I also watching your videos in YouTube. i hope you can help me on this situation.