Free 2014 Calendar, daily planner templates [download]

Posted on January 2nd, 2014 in Learn Excel - 39 comments

Here is a New year gift to all our readers – free 2014 Excel Calendar & daily planner Template.

free-calendar-and-daily-planner-template-2014

This calender has,

  • One page full calendar with notes, in 4 different color schemes
  • Daily event planner & tracker
  • 1 Mini calendar
  • Monthly calendar (prints to 12 pages)
  • Works for any year, just change year in Full tab.

See more snapshots here: 2014 Calendar template snapshot 1, snapshot 2

Download 2014 Calender – Excel File

Click below links to download the calendar you want:

How does this Calendar work?

This uses same techniques as mentioned in 2013 calendar. So check out this page to learn.

Go ahead and enjoy the download. The file is unlocked. So poke around the formulas and named ranges. Learn some Excel.

More Calendar Downloads:

Download these additional calendar templates and start your new year in awesome fashion!

2013 Calendar, 2012 Calendar, 2011 Calendar, New Year Resolution Tracker, Picture Calendar Template and Todo list template

Techniques used: INDEX | OFFSET| INDIRECT | Array Formulas | Using Date & Time in Excel | Conditional Formatting

Your email address is safe with us. Our policies

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

39 Responses to “Free 2014 Calendar, daily planner templates [download]”

  1. Wayne Lambert says:

    Hi,

    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 says:

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

      • Brent ovens says:

        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 says:

        Hi Wayne,

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

      • Singh says:

        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 says:

        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 says:

    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 says:

      Steve,

      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 says:

    Chandoo,

    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:

    http://sdrv.ms/1lCPNBB

    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!

  4. Matthew says:

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

  5. Segun says:

    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 says:

    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.

  9. eko sastra says:

    hi chandoo
    thanx for the calendar

  10. Frederick says:

    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.

    Regards
    Frederick

  11. Melissa says:

    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.
    Thanks!
    Melissa

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

    A big hug.

    AGUSTIN

  13. venkatpvc says:

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

  14. Donna says:

    Chandoo,
    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 says:

    Thank you for the interactive calendar!!!

  16. Robin says:

    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

    Robin

  17. Ranveer says:

    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 says:

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

  20. martin says:

    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:

    http://worktimesheet2014.blogspot.com.es/2014/01/calendar-2014-v3.html

  21. Moses says:

    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 says:

    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 says:

    Hi.

    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 says:

    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 : http://dl.free.fr/tv7IzxSJm

    Cheers

  25. Sophie says:

    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 says:

    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. […]

Leave a Reply