arrow41 Comments
  1. Wayne Lambert
    Jan 02 - 12:08 pm


    When I try to download the Excel 2010 versions of the calendars, I only get a ZIP file which does not include the .xlsx format of the file. It simply has a collection of XML files, etc.

    The 2003 link seems to be working as expected.

    • Chandoo
      Jan 02 - 1:10 pm

      @Wayne… you can try to open the ZIP file directly in Excel. Sometimes windows mistakes XLSX files as ZIP files.

      • Brent ovens
        Jan 02 - 6:23 pm

        I have the same issue as Wayne – I tried opening directly from Excel as well – there is no Excel file – only XML files that contain the macro codes. The 2003 version opened without a problem, but I can’t open the newer versions. Thanks for providing all these useful tools!

      • Wulfgar
        Jan 02 - 6:46 pm

        Hi Wayne,

        I had the same problem. Download the file, then change the extension to ‘.xlsx’. That worked for me. Good luck mate.

      • Singh
        Jan 02 - 6:59 pm

        Hi Chandoo,
        Thanks for sharing this.

        I extracted the files and saved on my computer and then tried opening the file from excel (like you mentioned). its not working for the excel 2010 version. 2003 link seems fine. There is no file with xlsx extention to open in excel. Can you please advice.

      • Nicoline
        Jan 04 - 5:12 pm

        You know Chandoo you are trully and utterly the best!!!
        I have a lot of these ‘zip’ files that opened in xml if I extract it, now thanks to your rename tip I can open it all
        Thank you, thank you, thank you!!!!
        Regards Nicoline

  2. Steve LeLaurin
    Jan 02 - 6:12 pm

    I like this calendar template, but can think of an enhancement to the monthly version: instead of each day being one cell, structure it that each day is displayed in one column but (say) 6 rows, with no row lines and a small font size. The first row would hold the day of the month, left justified with with a row height appropriate for a large font size, and the remaining 5 lines would be smaller heights, left justified and blank to allow for entering 5 appointments or reminders. Another nice twist would be a set of macros to click on to change font color of a designated cell to allow indicating certain events. Say, blue for “vacation”, red for dr’s appts, green for business appts, etc.

    • Rob T
      Jan 02 - 7:27 pm


      See my post below, with a link to a version I’ve played around with. While there is still a limit of one event per day, it follows your suggestion of having a row for the day number and another row for the details.

      It’s the week-starts-on-monday version, and I’ve made some other UK-centric changes, so it might not be suitable for you to use, but I think it’s a good example of some of the possibilities…

  3. Rob T
    Jan 02 - 7:20 pm


    I really like your calendar design, but I couldn’t resist making some changes. Take a look at this version and see what you think:

    Aside from some personal preference changes (daily event type names and colours – I like them bright!), the things I’ve added are:

    1. Monthly sheet shows the actual details of the daily events
    2. Mini calendar has event days highlighted
    3. Hyperlinks aplenty!…
    Daily event icons link to each day on Monthly sheet
    (placeholder icon for days with no events).
    Icons on Mini calendar link to months on Monthly sheet.
    Icon above each month on Monthly sheet links to Mini calendar.
    Every day box on monthly calendar links to that day on Daily events.
    I think this makes it much easier to navigate around the calendar and add events from whichever view you are in.

    Would love to know what you think!

    • Rob T
      Jan 02 - 7:41 pm

      It seems the above SkyDrive link goes straight to their horrible Web Editor, which removes some functionality (even if you do a Save As to download it!).

      Here’s a link to a zipped version, which should hopefully bypass the nonsense and proceed straight to download…

      • Chandoo
        Jan 03 - 4:42 am

        Very impressive Rob.. thanks for the mod.

      • Piyush
        Jan 03 - 7:55 am

        Hi Rob,

        none of your links working. Probably it may be due to using corporate LAN for accessing this site. Can you please upload it somewhere else where I can bypass my IT team and get it downloaded.


      • Chandoo
        Jan 03 - 8:07 am

        Hi Rob,

        I took the liberty of uploading your file to my site servers so that people can download it easily.

        Get it from

  4. Matthew
    Jan 03 - 6:17 am

    Thanks for the template, Chandoo. Really like this design.

  5. Segun
    Jan 03 - 9:49 am

    Thanks Chandoo for this 2014 calendar. This is unique. I just downloaded and just scan through it. The little makes me love it. I quickly liked and shared it with friends on facebook. Thanks so much.

  6. […] ??? ?? ???? ?????????. ? ????? ? ???? ??? Chandoo. ?? ??? ?????????? ?? ????? ????? ??????????? ?????? ????????? ?? 2014 ??? […]

  7. […] you’re planning your activities for 2014, you can download a free Excel calendar template from Chandoo’s website. You can see a screen shot of the calendar […]

  8. Megha
    Jan 06 - 12:29 pm

    I really love your calendar designs and download them every year. There is just one problem I face with them, whenever I go to print any of the template, the previous months dates are also displayed in shaded background in the print. Suggest a way to do away with it.

    • Hui...
      Jan 06 - 3:13 pm

      Check that you have set calculation to manual
      It should be on Automatic
      or press F9

  9. eko sastra
    Jan 06 - 4:20 pm

    hi chandoo
    thanx for the calendar

  10. Frederick
    Jan 07 - 9:00 am

    Hi Chandoo

    This is an amazing tool. Thank you for sharing your knowledge with us.
    How can I change the events (special )in the drop down boxes on the daily tab to suit my need or add extra.

    I’m still learning excel and always looking forward in receiving your newsletters.


  11. Melissa
    Jan 08 - 5:34 pm

    Hi Chandoo
    This calendar is excellent!
    I have the same question as Frederick. I’d like to add some categories & change what is already there.

  12. Hi Chandoo
    This calendar is a great tool, so I will share my blog with a link to download it my followers.

    A big hug.


  13. venkatpvc
    Jan 09 - 3:57 pm

    sir chandoo,
    your awesome. there is lot learn from you.

  14. Donna
    Jan 09 - 5:07 pm

    One of the best things about last year was discovering your website! As an excel beginner, I learned more than I ever thought I could. I never fail to smile, or even laugh, when I visit your website or read one of your newsletters. You manage to make learning excel interesting and fun at the same time. Your optimism is quite contagious! Thank you so very much for all that you do.

  15. Amy Sampels
    Jan 09 - 5:59 pm

    Thank you for the interactive calendar!!!

  16. Robin
    Jan 09 - 11:22 pm

    Hi there,

    i am trying to use one of the colour calendars that you’ve supplied but i can’t work out how to set up the daily events to it. Also how do you clear the holidays/vacations you’ve used in the template? the data validation for the drop down doesn’t have a ‘blank’ option or i’d just use the first one and clear everything to match Australia 🙂

    this is amazing though,

    many thanks


  17. Ranveer
    Jan 10 - 7:11 pm

    Thanks a lot Chando for this wonderful Calender in Excel. It will help me to manage my work effectively.

    Thanks Again!

  18. […] calendrier est une transposition dans Google Spreadsheet du calendrier proposé par Chandoo (voir ce billet), pour comprendre la construction du calendrier dans Excel allez sur ce billet en […]

  19. Rono
    Jan 11 - 5:32 pm

    I want to change weekly holiday to Friday instead of Sat & Sunday. Plz help

  20. martin
    Jan 14 - 11:23 pm

    I also made an Excel 2014 year calendar (and also a 2 year calendar 2014-2015 and the 2013-2014 school-calendar),you can download it from:

  21. Moses
    Jan 17 - 2:09 pm

    I just got an office job… and this website has been of great assitance to me in learning Microsoft Excel. Thanks to all the people who made this.

  22. Bernardo
    Feb 17 - 3:42 am

    Is there a possibilite of my notes apear on the full page, when i click on a specific day? I can´t see a reason for the Notes parte on the FULL tab.. Sorry, i am a really starter..

  23. Sharad
    Mar 14 - 5:13 pm


    I just came across this wonderful calendar. I always find it difficult to find out what week of the year it is on a particular day. Can someone help how to find it out easily in a calendar

  24. Baptiste
    Mar 18 - 10:16 am

    Hi there,

    here is Chandoo’s calendar with customizable:
    – starting day of the week (Sunday, Monday, …, Saturday)
    – abbreviation for days in your language

    You can download the file here :


  25. Sophie
    Mar 23 - 5:05 am

    Chandoo I love your calendar…it is really making me look like an Excel hero!! I have a q….I entered the 2014 Easter public holiday dates (18/4 & 21/4) into ‘Daily’. I then changed the year from ‘2014’ to ‘2013’, and then went back to ‘Daily’ to erase the 2014 Easter holiday dates and enter the 2013 Easter holiday dates (29/3 & 1/4). When I changed the year from 2013 to 2014 or 2012 etc on ‘Full’, the 2013 Easter holiday dates remained highlighted. I just wanted to check….if I want to be able to view a different set of highlighted events on the ‘Full’ worksheet whenever I change the year, is this possible or can I only save one set of annual events per template? Many thanks!

  26. […] Every year Chandoo releases a Yearly Calendar as a small gift to his readers. The 2014 calendar is available here. […]

  27. Zach
    Apr 10 - 8:52 pm

    Hi Chandoo, Thanks for yet another very useful and educational calendar tutorial.

    Question: Can the ‘2014 calendar daily planner template’ be modified so it will show the next 12 months from a given starting date/month? (rolling 12-months) For Example, I need a calendar that shows the next 12 months starting in May 2014 and ending in April 2015. How can I do that with this 2014 calendar template?

  28. […] This is very simple. Just create a daily or weekly plan of one activity that will improve your online marketing. The key is actually writing out a schedule and sticking with it. If you need a free source for downloading blank calendar templates, try this one. […]

    Jan 21 - 11:47 pm

    So beautiful calendar. Awesome!…

  30. […] This is very simple. Just create a daily or weekly plan of one activity that will improve your online marketing. The key is actually writing out a schedule and sticking with it. If you need a free source for downloading blank calendar templates, try this one. […]

Leave a Reply

Mobile Theme