Subscribe2013 Calendar – Excel Template [Downloads]
Here is a New year gift to all our readers – free 2013 Excel 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: 2013 Calendar template snapshot 1, snapshot 2
Download 2013 Calender – Excel File
Click below links to download the calendar you want:
- 2013 Calendar & Daily planner [Works in Excel 2007, 2010 & 2013]
- 2013 Calendar Template [Excel 2007, 2010 & 2013]
- 2013 Calendar Template [Excel 2003]
How does this Calendar work?
This is the same file as 2012 calendar with the year changed. The new feature is event planner. So I will explain that alone.
- First take a look at either 2011 calendar or 2012 calendar pages to see how the basic calendar is constructed.
- In the daily events tab, we have full calendar for 2013 (or any other specified year) listed one day per row (so maximum rows are 366).
- Each day can be marked as one of the 4 types of events – Important , Anniversary, Holiday or Vacation.
- When you mark a day with either of these 4 events, in an extra column, a formula determines which event it is and places a number (between 1 to 5 – 1 for Important, 2 for Anniversary … 5 for no event)
- Back in the full calendar, we use conditional formatting to color a day based on what number is associated with it in daily planner.
- COUNTIF formulas are used to count how many days are marked as Important, Anniversary or Holiday and summarized in the full calendar view.
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!
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
| ||||
|
| ||||
|
Leave a Reply
 |
Merry Christmas & Happy New Year 2013 | People & Websites that Helped me in 2012 [Thank you message] |  |
At Chandoo.org, I have one goal, "to make you awesome in excel and charting". This blog is started in 2007 and today has 450+ articles and tutorials on using excel, making better charts. 
38 Responses to “2013 Calendar – Excel Template [Downloads]”
Good one Chandoo!!
Cheers!!
Dibs
Thanks
Nice 1.
Excellent
simple always rocks inside ! ! !
Excellent
Great work chandu
hi Chandoo
i have a question – while this is an great calendar template, do you have one where the text/event appears in the the Monthly Calender (the one which prints to 12 pages)
Thanks
Madhu
See this Madhu… http://img.chandoo.org/d/2013-calendar-with-event-planner-v2.xlsx
Really greate Chandoo
Thanks! Awesome gift.
Not seeing the monthy calendar in this download. Just the 12 month, daily & mini.
Please download this version – http://img.chandoo.org/d/2013-calendar-with-event-planner-v2.xlsx it contains monthly calendar too with events marked.
Hi Chandoo
I have added the monthly calendar also to the events calendar. It is an awesome spreadsheet, thanx! One question as above, what is the quickest way to have the days coloured (maybe labelled?) for each monthly calendar to reflect the event colours of the ‘full’ tab? Looking for the quickest way to copy across the conditional formatting to the monthly tab also.
Thank again
Jason
@Jason: thanks. Since you and many others have asked for it, I modified the event calendar to show monthly calendars with event colors too. Download it from here:
http://img.chandoo.org/d/2013-calendar-with-event-planner-v2.xlsx
Regarding your question:
The quickest way to apply CF to monthly calendars is,
Thanks Chandoo! Much appreciated. I also just modified the event calendar myself to show calendars with events colours. I worked out how to merge the CF across to the Monthly calendar with no issues
Jason
Awesome
Excellent… work..
Good work Dear Chandoo.
Thank you..
Chandoo,
Thanks for building such a great resource and community on Excel.
My calendar is also focussed on events and holidays. User can enter up to 100 personal events that will be displayed on the calendar and also highlighted using conditional formatting. In addition, U.S. holidays are calculated and highlighted.
The calendar can be customized for any year, starting with any month, and the week can start with any day.
Available here: http://indzara.blogspot.com/2013/01/custom-printable-calendars-built-in.html
Feedback from this great community is welcome. Thanks.
I have also added a 2013 Tamil Calendar if anyone is interested in a calendar template with Tamil Nadu Government holidays and Tamil months.
http://indzara.blogspot.com/2013/01/2013TamilCalendar.html
This is awesome, thank you!
How do I change the titles of the event types? Probably pretty basic, but I am far from being an Excel guru. I love that it keeps count of the event types used in the notes area, it is great for keeping track of vacation time used.
[...] 2013 Calendar – Excel Template [...]
Wow!
I was looking for it 4 a long time. I need this!!
I change the colors and the labels to make it works in spanish
Have a question
How can i modify to have Mondays as first day of the week instead Sundays?
thank you so much!
Very useful resource, would be nice to collaborate with you on my new photo calendar website http://calendar.pdfcreations.com to customize events on pdf layouts.
your calendar helps me find certain at everything on my daily plans, right on my workbook. thanks a lot.
Chandoo. This is fantastic. A nice addition to the new 2013 calendar. Thanks for sharing the data and as usual THANKS.
Hi Chandoo,
Could you please let me know how to change your nice calendar just to have Monday as first day instead of Sunday ? Or can you please upload version with starting with Monday ?
Would appreciate this a lot !
Great work btw !!
rgrds,
slotbandit
Hi CHandoo
really good job,you are the best ,i will pass to visit you nexet week i m raghurama bahlan.
anyone can help ? how to set Monday as first in Chandoo calendar ??
@Slotbandit
On the Monthly Sheet
Change B5
From:=INDEX(m1_,1,(ROWS($B$5:B5)-1)*7+COLUMNS($B$5:B5))
To: =INDEX(m1_,1,(ROWS($B$5:B5)-0)*7+COLUMNS($B$5:B5)-6)
Make the same changes to the other months and calendars
Thanks a lot Ian !!
have a good day
Hey i was just wondering how can i change the daily drop down menu to
Appoinments
Campaigns
is it possible (or simple) to have the calendar start with a different month?
This is great!! I have MS excel 2010. I am trying to make a dropdown calendar. Having the toughest time with this. Co worker has MS Excel 2003 Same issue. Do you have something already made? Would appriciate it!!
This is fantastic, is there an academic version that goes from august ’13 – July ’14?
[...] If your events span several months, then you can use formulas to generate calendar. [...]
Dear Chandu,
Really Awesome
but I wnat to know how it convert or make 2014 calender, Pls give me suggestions.
This is particular item which i saw last 6 month but you prove it again that you are chandu.
Thanks Again
Hemant Rathi
Have you looked at the month of February when you change the year to 2026?
The first week is all blank.