Excel Templates | Excel Spreadsheets | Monthly Calendar



Monthly Calendar

Posted on November 10, 2009
Filed Under Calendar |



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.

Monthly Calendar

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.

Monthly Calendar Setup

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.


You can read and download my other templates below :

Tags: , , , , ,

Comments

18 Responses to “Monthly Calendar”

  1. bta on November 24th, 2009 9:19 pm

    how come the 5th and 6th weeks only show #NAAM?

  2. bta on November 27th, 2009 3:19 pm

    anybody??

  3. Mike Gonzalez on December 14th, 2009 10:35 pm

    Is there a way to print the pages in duplex mode (12 months worth)?

  4. No one on December 19th, 2009 8:46 pm

    What’s the password? I want to modify the thing.

  5. TB on December 21st, 2009 9:47 pm

    This is great!! Could you please provide the password, I need to modify as well. Thanks!

  6. jaz on December 22nd, 2009 10:51 am

    Could you please provide the password, I need to modify.Thanks!

  7. maggie on January 6th, 2010 4:37 pm

    is it possible to increase the number of holidays and important events?

  8. lad on January 6th, 2010 7:17 pm

    Yes, I have the same questions as those above: can I increase the number of holidays, etc, and most importantly, why does the last week and a half have #NAME? instead of the day? Thanks.

  9. lad on January 6th, 2010 8:32 pm

    FYI…For the #NAME? issue, you need to install the Analysis ToolPak add-in.

  10. Nipa on January 7th, 2010 6:52 pm

    where can I find the analysis toolpak?

  11. Rory on January 8th, 2010 11:42 am

    This is really nice form!
    I will work nicely but, I would like to add 5 more columns to the calendar. Could you please provide the password?
    Thank You, Rory

  12. Modzy on January 9th, 2010 7:47 am

    You Guy should read the direction Firstly. You just add on Events and Holiday in to-do list. Then those will appear in the Calendar autometically. Just add on to do list. ^_^

  13. Mark on January 13th, 2010 2:25 am

    Hi! Maay I please have the password. Thank You

  14. R. Musadya on January 19th, 2010 3:24 am

    For those who has #NAME problems :

    Activate analysis toolpak add-ins in your excel. Go to excel menu > tools > add-ins and tick the analysis toolpak. And all function should work correctly. If you still have problem after following these steps, just close your excel and open it again.

    Regards

  15. Anand on January 25th, 2010 9:38 pm

    Hi

    By adding the analysis “toolpak”. It still does not take care of the “#Name” problems in the last few rows. Any fixes for that.

    Thanks
    Anand

  16. Na-Na-Natalie on February 7th, 2010 3:02 am

    Great site! I like the style of your templates. Check some of mine out.

  17. James on February 16th, 2010 9:13 am

    Hi
    With small changes to fit to me, it would be great.
    Can I have the password?
    Many thanks.

  18. Mark on March 5th, 2010 9:29 pm

    This works great…is there any way to have more than 6 task per day. I need up to 20..

Leave a Reply