Excel Templates | Excel Spreadsheets | Excel Calendar 2009

Excel Calendar 2009

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

Less than two months we will enter the year of 2009. Usually around this time, I am looking for the new design of excel calendar, but this year is different. I plan to make my own excel calendar, so I can define anything I want in this calendar.

Excel Calendar 2009


What I want to have in my calendar is a flexibility to change my holiday and event date without changing the appearance of the cell containing the date manually. It is annoyed me. The thought is how to make the appearance of the cells changed automatically everytime I change the date of the holiday/event or add the new holiday/event in separate cells. And after several layout changing, I made this calendar as you can see in the picture, where I made the column for holidays and event where I can fill or copy my holiday and event in those columns and see the corresponding date in the calendar changed its appearance. And you can do this also with this excel spreadsheet.

I add also another function which will make this calendar not just as an excel calendar 2009 but also become a perpetual calendar that you can use everytime the year is changed either forward or backward.

You are free to change the layout or the appearance of this calendar according to your preferences.

You can download this calendar here.

You can download the openoffice version here

Happy new year!


(Visited 3,560 times, 4 visits today)


13 Responses to “Excel Calendar 2009”

  1. Top 5 Excel Yearly Calendar » Excel Spreadsheet on March 12th, 2009 3:37 pm

    […] Download […]

  2. Gloria on May 6th, 2009 7:42 am

    Hi! I would like to change it to year 2010 and add more colors. Can you tell me how to do that? Thanks!

  3. admin on May 9th, 2009 2:32 pm

    You can download my yearly calendar where you can change the year and all dates will be adjusted automatically.


  4. Dawn on May 19th, 2009 3:59 am

    This is exactly the format for a calendar I’ve been looking for, thanks!! I was wondering if you could let me know how to add more colors for other categories?

  5. Susan on August 10th, 2009 2:20 pm

    For all months, the dates on the 5th and 6th rows show up as ####. What is wrong?

  6. admin on August 10th, 2009 3:24 pm

    Hi Susan,

    You should activate the analysis toolpak add-ins in excel to make the excel function work properly. Go to menu > Tools > Add-Ins, tick the Analysis Toolpak and press OK.


  7. dawcha on August 31st, 2009 9:03 pm

    Brilliant templates here. I am hoping to change the academic calendar to the same format as the excel calendar 2009 as I would like to have the academic calendar and the holidays/events on the same page (makes viewing so much easier). Also, I’m going to try have more colors for different events in the academic year. Any tips would be helpful. Thanks

  8. Charles on September 30th, 2009 1:28 am

    Excellent template and just the one I am looking for (especially the holidays and events). Unfortunately when I changed the year to 2010, the colors for holidays and events disappeared from the calendar. How can i fix this?

  9. Charles on September 30th, 2009 2:17 am

    I figured it out!!

  10. Tina Hall on October 18th, 2009 3:30 am

    Are you going to make a 2010 version of the Excel Calendar 2009?
    I find it really useful to keep track of events we’re running at our small charity.
    Thank you for your help.

  11. syam on October 23rd, 2009 3:12 am

    can i have the password so i can study it?

  12. Souliphonesith on July 28th, 2011 3:37 am

    Do you have excel calendar 2011, 2012?
    It will us a lot to record the activities

  13. Mike on September 7th, 2012 12:35 am

    How can I modify the calendar without the password? I was trying to move the two columns and put them on another tab. I guess you don’t give out the password, right?

Leave a Reply