Free 2015 Calendar, daily planner templates [download]

Posted on January 2nd, 2015 in Learn Excel - 19 comments

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

2015-calendar-template

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: 2015 Calendar template snapshot 1, snapshot 2

Download 2015 Calender – Excel File

Click below links to download the calendar you want:

How does this Calendar work?

This uses same techniques as mentioned in previous calendars. 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!

2014 Calendar2013 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

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

19 Responses to “Free 2015 Calendar, daily planner templates [download]”

  1. Deepak says:

    Links are dead.

  2. Rino Lattanzio says:

    Files are corrupt when Excel 2010 opens.

  3. GMF says:

    Chandoo, thanks as always for inspirational work. I intend to adapt this to some of my project spreadsheets. One question, and I apologize if the answer is something incredibly basic that I should know.

    On the named ranges, DateofFirst shows for August (row 13) as =DATE(YEAR(Mini!$B$5),MONTH(Mini!$B13),1). If I place the cursor in July it then shows as =DATE(YEAR(Mini!$B$5),MONTH(Mini!$B12),1) in the Name Manager window. How did you enter the formula such that it shows a different value based on the current location of the cursor without the named formula itself having a value to identify the active cell?

  4. GMF says:

    Ahhh. I get to learn yet something else new having never used a relative reference! I see from playing with it that it depends where the cursor is when you set up the relative reference, rather than the cell you enter, that determines the subsequent offset. So if my cursor is in row 19, and I enter B2 as my starting point in the formula, when I'm in row 20 the named range returns B3!

    Maybe this is a topic for a future Chandoo column... I'm curious why using the relative reference rather than the same existing date in column B is appropriate... In other words, B12 already contains 42186. I don't know how Excel stores the relative references for DateofFirst. Are there 1+ million values representing each row, or does the reference only exist for the 12 rows that point to it?

  5. Steve says:

    Unfortunately, the calendar doesn't work when opened. Just a bunch of hash tags and zeroes are displayed. Is there any way to upload a screenshot (.jpg) here, so you'll know what I mean?

  6. Shadeva Reddy says:

    Hello Sir,

    Thank you very much for this calender, its very nice and innovative one.
    It would have been more useful if we can have a column in the Sheet Full which would reflect the entries for that day when I select a particular date.This would be the summary of the entries that I entered in Notes in the sheet "Daily".This would make the sheet more User friendly.

    This is just a suggestion which I would feel would work, apologies if this was already worked but left out as this might not work.

    Regards,
    Sahadeva Reddy

  7. CHANDINI says:

    Good year planner.
    Helpful in many aspects of my job.
    Regards.
    Chandini

  8. manikant yadav says:

    thanks happy new year 2015 nice calender and usefuls daily use i am very happy

  9. S HUSSAIN says:

    I usually don't get gifts - thanks for such an educational and very useful tool - a Happy and Prosperous 2015 to all Excel-Thrill seekers out there.

    I wonder if it is polite to ask so early into 2015 for an advice on how to subtract one cell content from another, both containing TIMES in this format HH:MM:SS with the results shown as duration in this way HH:MM:SS - without converting into any other values or formats.

  10. zamapon says:

    This is so helpful 2015 Calendar & Daily planner, I love it.
    Thanks for your great work and sharing your ideas.

  11. Pintu Soni says:

    Hi Chandoo,

    Thanks a lot for the Calendar, it is really awesome. I just noticed that if the year 2015 is changed to 2016 or 2017 it still works fine so I think this can be used in the coming years as well.

    Thanks again and God Bless.

  12. Emmanuel says:

    2015 Calendar. File does not open, says either extension is not valid or file is corrupt, is there something I'm doing wrong as it appears others have opened it?

  13. […] Ben je geïnteresseerd in de oorspronkelijke kalender (en meer van het werk van Chandoo) en zijn achtergrondartikelen: kijk dan op Chandoo.org. […]

  14. Mahir says:

    Hi Chandoo,

    I am using your Calendar template already on a daily basis.

    I've added an array formula to the "Notes" column: ={IFERROR(INDEX(DAY(Daily!$C$5:$C$369)&"."&MONTH(Daily!$C$5:$C$369)&"|"&Daily!$E5$:$E$369,SMALL(IF((Daily!$D$5:$D$369="Important")*MONTH(Daily!$C$5:$C$369=MONTH(TODAY())),ROW(Daily!$E$5:$E$369)-ROW(Daily!$E$5)+1),ROWS($AA$5:AA5))),"")}

    With this Formula I get all "important" Notes for the actual month.

    Now I tried to use CF to Highlight the actual date. The actual date should have a red border, so that I know with one view, which date we have. Furthermore I thought the days that we left behind could be in a duller shade with some background styles applied.

    I failed very bad, so that I can not share anything. I even tried to use the DATE() Function in Combination with the TODAY() Function, but somehow it did not work.

    Are my CF Ideas possible? and if so, could you show me some hints and tricks to achieve the result described above.

  15. AZSundog says:

    File is corrupted won't open. I downloaded the one for 2013 as I am running Office 2013. I have enabled all macros in the developer tab.

  16. paulod says:

    This calendar all works perfectly and I have adapted it to suit my needs and I even added a column to give 10 days notice of impending meetings from which I've made another calendar.
    If there is solution to my problem of using this spreadsheet to automatically put the meeting dates and impending dates into an Outlook 365 calendar (and update any changes) I'd be grateful and keen to know.

  17. Yasir says:

    Fantastic work and Good that you are spreading the knowledge. Keep it Up.

  18. Mahdiest says:

    HI ALL!

    Happy new year 2016

    We wait with patience the calendar 2016

    Thanks 🙂

Leave a Reply