This monthly calendar is an extension of monthly event calendar 2009 I have made a year ago. There are many improvements I have made in this calendar. Compare to the previous one, this calendar can accommodate until 6 to-do list or events at the same dates. And you still can put additional one holiday or one important event on top of the row. And there are additional columns where you can put your time consideration of those events or you can leave it blanks.
There are two worksheets that are shown in this spreadsheet, the first one is “todo-holiday-event” worksheet. And you can start to use it as your 2010 monthly calendar by setting the month and the year in the first rows of this worksheet to January 2010. You change it according to your preference. After that, you can put your to-do list in to-do list column. You can use this list as your reminder list also. For example, you can put your favorite movies schedule, your concert show, your favorite sport teams schedule etc. And you don’t have to type it in sequence, because the excel formula will display and order it automatically in the calendar. So, you can add it anytime without thinking of ordering the dates.
The second column is a holiday column. There are US holidays time that I put as a default. You can change it based on your country national holiday, or your own private holiday. The description of the holiday will be displayed next to the date of the calendar and the row of that date will turn into red.
The third column is an important event column. In case you want to separate your important event with your to-do list, like your birthday or your beloved one birthday, you can put it in here where the event will be displayed differently in the calendar. It will be displayed next to the date of the calendar with blue color. It will share the place with the holiday information. So, if the important event and holiday are happened at the same date, the important event will become priority to be displayed.
The second worksheet is a calendar worksheet where you can see your customize calendar before you print it. There is a slider tool on top of the calendar that you can use to slide between months. You can slide it right to go to the next month and slide it left to go back.
That’s all guys. You can download it here.