Free Excel Calendar Template for year 2009 (and all years up to 9999)

Featured , Learn Excel , personal - 21 comments

First a bad news: I am leaving to India tomorrow and that means there will not be many blog posts in the next week or so. Once I reach home and get an internet connection, the updates should be regular.

Now the good news: free excel calendar template for year 2009 (well, it works for any year all the way up to 9999)

Go ahead and download it, change the year number in the first sheet to 1981 or something and see the magic.

More importantly, the workbook is unlocked so you can see what formulas are being used. There is a worksheet named “mini” which calculates the calendar dates and weekdays for the year specified by you. Once that is done, I have used references to create a 12 month view in the first sheet.

There are 12 more sheets each for one month in the year. These sheets use a combination of named range based references along with cell() formula to automate the whole thing. Oh yeah, they also use camera tool outputs to show you previous and next month calendar views.

So, download, share it with a colleague or use it as you wish: Excel Calendar for year 2009 – Download and Print Free

PS:  I have tested this in Excel 2003 and I guess it should work the same way in 2007. Let me know if you see something funny.


Hello Awesome...

My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.

I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.

Thank you and see you around.

Related articles:

Written by Chandoo
Tags: , , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

21 Responses to “Free Excel Calendar Template for year 2009 (and all years up to 9999)”

  1. Felipe Chaves says:

    Hey Chandoo! 9999 is equal to 2010! Thanks for the post fellow! I hoppe everything is fine with you!

    Best regards

  2. fchaves says:

    Hey Chandoo check it out! 9999=2010

    Thanks for the post!

    Best regards

  3. Stružák says:

    Hi, would you mind publishing a calender template with weeks starting with Monday instead of Sunday?

  4. Mathus says:


    very good things.
    But nothing happen after i change the year in the first worksheets.
    any suggestion?

  5. Bhars says:

    Wonderful calendar!! Thanks a lot!

  6. Pankaj Verma says:

    Know what - I wonder, perplexed and bewildered to think that when do you get the time to experiment these things, yaar. Would you mind telling me the secret.

    One more thing - "First a bad news: I am leaving to India tomorrow" left me little dumbfounded initially. Then I realised you meant "there will not be many blog posts in the next week or so". Hey Hey Hey......

    Welcome home bro.


    Pankaj Verma

  7. Chandoo says:

    @Felipe: really? When I tested, 9999 would produce some # errors and I didn't bother checking them.

    @Struzak: sure... But as noted, I have moved to India and would need few more days to settle here. Meanwhile, it is fairly easy to change the week orientation and have the calendar your way. Just adjust the formulas. If you do that, feel free to send it to me so that I can upload that version for everyone 🙂

    @Mathus: are you sure? what version of excel are you using? and do you by any chance have manual mode for formula calculation. In that case you may want to press F9 to recalc the dates.

    @Bhars: You are welcome 🙂

    @Pankaj: I am so happy to come home after an year in US. I guess my sentence construction wasnt that good :D, and yeah, there is no secret. I just explore this stuff in free time at work and home and push worthwhile ideas here. 🙂

  8. Stružák says:

    @Chandoo: Sure. I'll send it to you via e-mail within few hours. 🙂

  9. Mrayo84 says:

    I bet orange is your favorite color

  10. Debra McLaren says:

    Thanks for the calendar, not too sure about the leap years last millennium though... 1900 and 1700 were not leap years but 1600 was...

  11. Chandoo says:

    @Struzak: Awesome... I will upload it once I check it... 🙂
    @Mrayo84: There are very few good colors in excel palette and orange is my fav ... yes.. 🙂

  12. Michele says:

    You are my favorite!

  13. Axel says:

    Chandoo, great present for Christmas and for years to come! Many Thanks!

  14. [...] one of the commenters on the 2009 Excel Calendar Template post asked me if I can rearrange the cells in the calendar so that the week could start on Monday. Since [...]

  15. Antoon says:

    The zip file seems to be corrupted. Can somebody post a working version?

  16. Chandoo says:

    @Antoon: Welcome to PHD... I have just downloaded the file and it is working fine for me. Can you try downloading the file from a different internet connection (may be) ? Let me know if it doesnt work, I can email the file to you.

  17. Antoon says:

    @Chandoo: yes, please. I tried it using two providers and two browsers. In every case I get a message that the file is corrupted....

  18. Cindi says:

    Thanks, Chandoo. Awesome calendar and easy to work with/modify. You're a whiz!

  19. I would like to get across my gratitude for your generosity for people that need help on this important idea. Your very own commitment to passing the message all-around had become amazingly beneficial and have continuously allowed workers much like me to attain their pursuits. Your own important guideline denotes a whole lot a person like me and somewhat more to my office workers. Many thanks; from each one of us.

  20. […] Excel Calendar for Year 2009 and beyond […]

Leave a Reply

« »