Excel Templates | Excel Spreadsheets | Monthly Event Calendar 2009

Monthly Event Calendar 2009

Posted on November 11, 2008
Filed Under Calendar | 15 Comments

Following the soccer fixtures and excel calendar 2009 I made, I got another idea about putting my favourite teams fixtures in calendar, and try to make it automatic, so I can changed the date, the team or add the new date or team easily or even combine the soccer league fixtures, the champions league fixtures and Formula 1 schedules.  That is the first idea, because there are still many ideas that can be implemented in this event calendar. 

I have divided this excel spreadsheet into three different layouts. And the first one is one month layout. I add the capability to change not just the month but also the year, so you can use this every year.

Monthly Event Calendar


The guidance for using this spreadsheet are as follows :

1. This is the one month event calendar where you can only see the event only for the month and the year that you fill on the corresponding cells.

2. Enter the date and the corresponding event in the blue cells at the left side. You can fill one by one or just copy the date and event from other sources. You don’t have to fill it in order, as you see in the sample data in the spreadsheets, I put the fixtures of AC Milan from Italian Serie A fixtures and followed by the fixtures from Barcelona. You can put the champions league event or Formula 1 or MotoGP or your lover birthday after that. The formula inside the calendar cell will find the corresponding event automatically.

3. I limit that only 3 (three) events can be shown in the corresponding date, so if there is more than 3 events at the same date, only the top three events in the event columns will be shown.

4. You can change the lay out, the colour or change the cell format, but please be careful with the formula, especially the formula that return error result, since I have to cover it using white colour. I protect this sheet without password, so you can just unprotect this sheet from the excel menu.

5. Finally, if you make some changes in this excel spreadsheet or rename to other name, I would be pleased if you keep my link available in the spreadsheet. 

You can download this spreadsheet here.

If you are using Openoffice, you can download openoffice version here 

Have fun.

(Visited 1,498 times, 1 visits today)


15 Responses to “Monthly Event Calendar 2009”

  1. Noel Colon on April 23rd, 2009 9:04 pm


    I just download you 3 & 6 month calenders but the all have in error after the 24th of every month can you fix that?

    Thanks in Advance

  2. admin on May 9th, 2009 2:17 pm

    Hi Noel,

    You should activate the “Analysis ToolPack” Add-ins in your excel. By, default excel doesn’t activate this add-ins. Go to menu Tools > Add-Ins and you tick Analysis ToolPak and your problem will be solved.


  3. Terri H on May 31st, 2009 3:25 pm

    Wow, what a great tool you have offered, and obviously spent some time developing! I saw this and immediately thought about using it for a bill-due-dt calendar.

    Unfortunately, we have a LOT of bills and in some cases, I need more than the 3 lines available. I tried to add the additional rows, but can’t seem to get the formula right, and while I understand basic, simple formulas, this one has gone past my limited ability.

    Could you give me any advice on how to go about this? Just thought I’d ask for a little guidance, however, I DO understand if you don’t have the time nor inclination, since you ARE offering this for free, of course.

    Thanks again for your hard work & effort.

  4. George A on August 27th, 2009 2:51 pm

    Great calendar tool. Any chance you have a version that allows for and shows events that span multiple dates?
    Thanks again for your great effort!

  5. guru on September 11th, 2009 11:28 am

    gr8 work… it is really useful for all my planning…keep it up

  6. William Greenberg on October 6th, 2009 1:51 pm

    I noticed that a couple of people had asked about adding rows to each date, but I did not see a response. I just thought I would ask again. Could you help me figure out how to do this?

  7. Kurt on January 19th, 2010 8:02 pm

    Is there a way to link several dates together such as; “Vacation 1-14 through 1-25-2010” having this time period linked or illustrated as one event occurring over several days? I am using Monthly Calendar. Thanks :)

  8. Diana on March 24th, 2010 11:26 pm

    I am impressed of the templates I found here. Excellent work! Congratulations and thank you for sharing!

    I try to create an annual holiday planner for a large number of staff. Any suggestions?

    Thank you,

  9. Fez on August 30th, 2010 2:16 am

    First of all i would like to let you know that your work is Phenomenal and I admire it. gr8 work. I have donwloaded your Monthly Event Excel Calendar and it works perfect. Just would like to ask you is there a way to make 3 events per day to 5 events per day? Can you help me to add 2 more event per day? I would appreciate you help.

    Thank you,

  10. Drip Tray : on November 1st, 2010 2:54 am

    some big websites and companies give free calendars ~

  11. Chair Pads %0A on December 1st, 2010 5:32 pm

    i would love to get some free calendars on the internet, are there are sites or company that gives one? -:”

  12. Brigitte on February 10th, 2011 5:23 am

    hello I am using the Event Planner calendar – we love it but we need more than three line items in the calendar section per date. We would like to have 6 lines of availability for each date within the calendar – how do we do that? Thanks so much these are really great resources.

  13. RoxAnn on January 10th, 2012 4:38 pm

    do you have this updated for 2012? it won’t let me change 2009. thx

  14. Dale Hallam on February 11th, 2012 10:57 pm

    I really like this event calendar and it could help me greatly but I am unable to change the year or month without errors. Could I know if there are any fixes for this.

    Thank You in advance.

  15. Ange on November 8th, 2013 12:09 am

    Hi, this is a great planner that I want to use for my work but I am having trouble when I unprotect the sheet and add in my data it doensn’t keep the formula year by year or month by month, instead it all is the same data – please help! Thank you =]

Leave a Reply