Excel Templates | Excel Spreadsheets | Monthly Calendar



Monthly Calendar

Posted on November 10, 2009
Filed Under Calendar | 59 Comments

Pin It

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.



Tags: , , , , ,

Comments

59 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..

  19. stephanie on March 20th, 2010 12:30 am

    This is great! Exactly what I need but would love to have the password because I need to add additional rows to the date (have more than 6 events in a day). Additionally, I have over 700 events and this calendar only takes up to 250 events.

  20. Samuel A. Altéa on April 8th, 2010 3:25 am

    Olá Pessoal. Não estou conseguindo baixar a planilha.
    Quando clico em: Você pode baixá-lo aqui, abre outra tela apenas com o formato da planilhe em html.
    Por gentileza, alguem pode me ajudar.

    Grato.

    Samuel

  21. Rui on April 13th, 2010 4:20 pm

    Guys, excellent work on the templates. Could provide me with the password for Monthly Calendar?
    Thanks

  22. Amyn on April 19th, 2010 8:44 am

    Can you provide me password as i need to make some modification.

    Regards
    Amyn

  23. Peedy on April 21st, 2010 11:54 pm

    Hi Admin.

    can you please add match prediction functionality?

    Thanks :)

  24. Peedy on April 21st, 2010 11:56 pm

    Sorry last comment was for the Soccer world cup spreadsheet lol

  25. Maddy on April 26th, 2010 1:41 pm

    HI
    Thank you for this!! Its a great tool.
    I’d like to change the formatting to my colour-scheme on the Calender, but need the password.
    Would you mind providing that?
    Thanks!

  26. Sarah on May 6th, 2010 11:41 pm

    Hi Hi,

    Can anyone please tell me how to add another category? I.e, there is TO DO, HOLIDAY and IMPORTANT EVENT but I need to add TWO more categories, can anyone help??

    Thanks!

    Sarah

  27. Sarah on May 7th, 2010 12:29 am

    Hello?! Can anyone please help me?

    Thanks!

  28. Linda Shaffer on May 11th, 2010 7:08 pm

    Hi, Love the template, but the calendar lines prints out too lightly on my black and white printer. I would like to be able to modify the borders so they print out more darkly; can’t see them as is.

    Also, encountered a strange copy paste issue when I copied a group of dates/descriptions to the task area (dates were mysteriously shifted by 1 day and 4 years)

  29. fido on May 23rd, 2010 9:29 pm

    ARRRRRRRRRRRRRRRRRRRRRRRRR!!!!!!!!!!!!
    PAAAAAASSSSSSWWWWWWOOOOOOOORRRD !!!!!!!!!!!!

  30. Neo Nguyen on May 30th, 2010 2:47 am

    HI admin,

    It’s very useful for my job, but could you please help me to supply password for any modify with my job…

    thanks for sharing.

    Vinh

  31. Jake on May 31st, 2010 11:47 am

    I would very much appreciate your help in modifying this excel template into a limited reservation list.
    I work for a very large hospital, and we would like to use it as a backup list for patients who attend our clinic.
    Please contact me if you are interested. I am sure the demand for this type of calender list is enormous.

  32. Lex on July 22nd, 2010 2:12 am

    Is there any way of making the fonts larger or bold?

  33. Catherine on August 5th, 2010 9:26 am

    This may sound like a foolish question, but in daily planner, once I have set up my holidays and important dates, how do a go to the next day and set up that day – . Can you tell I am new to excel. My husband and I just started running a hockey rink with one ice surface and need to schedule the ice time starting at 6:00am and ending at 11:00pm, each slot bing only 50 minutes. with the next ice time starting on the hour. I feel so inept with excel!!! Scarry to think that I learned on a WANG – they are in the smithsonian now!

    Thanks for any help.

    Catherine in Boston

  34. Candy on September 8th, 2010 3:25 am

    This is so suitable for me.
    May i know how to add more “month”?
    i would like to add it upto 2012 as well.

    Hope to hear from your soonest response!
    Thank you so much!

  35. Skeeter on September 15th, 2010 11:31 pm

    This calendar is very useful, but I would like to make a cuple of changes. Can you supply the password.
    thanks for your help.
    Skeeter

  36. Stef on October 11th, 2010 2:43 pm

    With Analysis Toolkit activated -> WORKS LIKE A CHARM!!!

    but: can I pls have the password?

    tx
    Stef

  37. Jan on October 17th, 2010 12:08 am

    I love your monthly calendar template. My problem is that I have 650 events. I tried to modify the formula to extend the range, but it had no effect. Is there a way to make it work?

  38. Jan on October 18th, 2010 1:52 am

    Oh – never mind. I figured it out!

    Thanks!

  39. Keith on November 1st, 2010 8:24 pm

    Love the calendar, can I get the password for some reason events are not showing after Nov 6, 2010. I would laso like to make some modifications

  40. Keith Beaulieu on November 5th, 2010 6:07 pm

    Love the calendar, can I get the password for some reason events are not showing after Nov 6, 2010. I would laso like to make some modifications

  41. Karen Bilton on November 15th, 2010 8:59 pm

    How do I get rid of the #NAME? issues in the last two rows and is it possible to have the password so I can modify it. This is just what I need to create an automatic planner.
    Thank you in anticipation.

  42. Tiru on December 16th, 2010 1:59 pm

    This calendar is very useful, but I would like to make a cuple of changes. Can you share the password.

    thanks for your help.
    Tiru

  43. mohamed on January 3rd, 2011 12:45 pm

    thankssssssssssssssss

  44. mohamed on January 3rd, 2011 12:46 pm

    thankssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss

  45. Sean on February 8th, 2011 5:48 pm

    To fix the #NAME error in the 2nd month of the calendar on “Supporting Calendar”, just go into the cell in B14, click F2 and hit Enter.

    Not sure why, but it just needs to be recalculated for it to work.

  46. Sean on February 8th, 2011 5:48 pm

    To unprotect any sheet, just go to Protection > Unprotect sheet. There is no password required.

  47. yiangos on February 12th, 2011 5:12 pm

    how kan i get more than 250 events?? someone

  48. Russ B on February 14th, 2011 1:33 pm

    How do I unshade the dates? Some have blue shading.

  49. Russ B on February 14th, 2011 6:27 pm

    Found it. To clear the shading go to Conditional Formating and “Clear the Rules.” Thanks for a great spreadsheet.

  50. John on February 18th, 2011 3:15 pm

    How do I enter more data then the fomula’s are allowing. I tried to change the foumula’s but it didn’t work.

    Thanks,
    John

  51. Paulo Chagas on May 9th, 2011 11:25 pm

    This calendar is very useful, but I would like to make a cuple of changes. Can you share the password.
    thanks for your help.
    Paulo Chagas

  52. MHRN on June 12th, 2011 10:31 pm

    ??? ??? ??????? 20??????? 1????? ??? ?????

  53. Amber on November 18th, 2011 3:11 am

    I was curious about your monthly calendar if there was a way to make the monthly one a bill pay calendar. I like the way the data entry part works. Is it possible to make the time a “Balance due” or “Amnt Paid” and then on the right hand side of the calendar it will give you an up to date balance of all of your bills? I’m not sure I’m explaining this well lol.

  54. David caga on January 16th, 2012 11:33 pm

    May i have the password.. this template would really help… Thank you!

  55. Nina on January 24th, 2012 6:51 pm

    Hi, love the template. I have tweaked it a lot. Would love to have the password for the hidden sheet, if you could provide it I would greatly appreciate it.

  56. RoxAnn on February 2nd, 2012 6:21 pm

    do you have one of these for 2012? it won’t let me change the 2010 to 2012. Thanks!

  57. Angelko on March 4th, 2012 9:25 am

    I like to work with excel, to be honest I have never seen a such beautiful work, it is thanks to people like you that I love so much to work with excel.

    Just one question, can I add more worksheet, if yes, how can I modify the formula

    thanks again

    best

  58. Desmond on June 20th, 2012 3:05 am

    Answers to these 2 possibly very simple questions would help me immensely in my work:

    - Can I enter a date range (e.g. 20/6/12 – 25/6/12) such that it would be reflected in the Calendar tab?

    - How can I get the calendar to show more than 7 events?

    Thanks in advance to the good Samaritans!

  59. SWoods on September 3rd, 2012 6:25 am

    Hi there – any chance you could help re: the formatting of additional holidays and events? Have worked out how to get it to pick them up from my lists, but not the formatting in red or blue. Thanks!

Leave a Reply