Close this search box.

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



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.


Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Announcing Power BI Dashboard Contest 2024

Announcing Power BI Dashboard Contest (win $500 prizes!)

Hey there, I have a SUPER exciting announcement! April is about to get a whole lot sweeter with our Power BI Dashboard Contest! Your mission, should you choose to accept it: Craft the most EPIC dashboard for the Awesome Chocolates CEO with sales & financial insights! Winners stand a chance to score up to $500 in Amazon Gift Cards, plus some serious bragging rights!

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