Excel Calendar Template – 17 Calendar Designs in Excel – Free Download

Posted on
2017 Calendar Design 2 - 1 Page 12 Months - 3 X 4

I am very pleased to present the new Excel Calendar template. Download this new Calendar Excel template and create your own personalized calendars in Excel.

In this post, we will be discussing the following.

  1. Features of the Calendar template
  2. Link to download template for free
  3. Instructions to use the template
  4. 17 Calendar designs
  5. Tips to further customize the template

 

Monthly Calendar Sample From 2017 Excel Calendar Template
Monthly Calendar Sample From 2017 Excel Calendar Template

 

FEATURES OF CALENDAR TEMPLATE

  • Customize calendars by choosing the Year, Starting month and Starting day of week.
  • Enter Holidays and Personal Events to display on the Calendars
  • Automatically creates 17 Calendar designs (No points for guessing why 17 ūüôā )
    • 10 (of the 17) designs automatically list the Holidays and events
    • 2 (of the 17) designs allow typing events directly on the calendar itself
  • All 17 designs are ready to be printed. Can be Exported to PDF as well.
  • Easy to change formatting (font size, font, text colors, fill colors)

 

DOWNLOAD CALENDAR TEMPLATE

Calendar Excel Template

2017 Calendar with US Holidays

 

VIDEO DEMO

 

HOW TO CREATE CALENDAR

Overview of steps

  1. Enter Basic settings
  2. Choose Weekends
  3. Enter Holidays
  4. Enter your personal or company Events
  5. Pick a Calendar design
  6. Print or export the calendar to PDF

 

Now, let’s see each step in detail.

Step 1: Enter Basic settings

 

Enter Basic Settings for 2017 Calendar Year Month Week Begin Day and Name
Enter Basic Settings for 2017 Calendar Year Month Week Begin Day and Name

 

Enter the year for which you want to build the calendar. Even though I created this from scratch just for 2017, I designed it such that you can enter any year and the calendar will still work. ūüôā

By default the year begins in January. However, you can modify that to start the calendar with any month.

Choose Starting Month for the Calendar in Excel Template
Choose Starting Month for the Calendar in Excel Template

 

By default, the calendar shows weeks starting in Sunday. However, you can modify it to start with any weekday.

Choose Starting Day of Week for the Calendar in Excel Template
Choose Starting Day of Week for the Calendar in Excel Template

 

We can give a name to our calendar and the name will appear on some of the calendar designs automatically.

 

Step 2. Choose Weekends

Choose Weekend days to highlight on Calendar
Choose Weekend days to highlight on Calendar

 

Calendars show weekend days in red colored font. You can modify the weekends as needed for your purpose. In the image above, I have selected Saturday and Sunday as weekends. So, all Saturdays and Sundays will be shown in red font on the calendars.

 

Step 3: Enter Holidays

Enter the list of holidays for your company or business in the Holidays table.

I have provided a list of holidays in U.S. and India for reference. Please see the Holidays sheet.

Enter Holidays with dates and names for Calendar
Enter Holidays with dates and names for Calendar

 

I have used Excel Tables for user input. If you are new to Excel tables, please see my article on How to use Excel tables for data entry?

 

Step 4: Enter your personal or company Events

The template allows the user to enter events, in addition to holidays, to display on the calendars.

Enter calendar Events with dates and names
Enter calendar Events with dates and names

 

If you are using this template for personal calendar, you can enter your personal events as I have done in the above image.

If you need to create a calendar for your company, enter your company events for 2017 in the Events table.

 

Step 5: Pick a calendar design from the 17 designs

Based on the input provided in the previous 4 steps, the template builds the calendar designs. The 2017 calendar template offers 17 different calendar designs to choose from. In the Pick a Calendar sheet, we can see the 17 designs.

17 Calendar designs for 2017 Excel Calendar
17 Calendar designs for 2017 Excel Calendar

 

Just click on any design on and you will be taken to the corresponding calendar sheet.

You can also directly go to any of the sheets named 1 to 17.

Sheets in the Excel 2017 Calendar Template
Sheets in the Excel 2017 Calendar Template

 

Note: If you change the sheet names of the calendars, then hyperlinks in the Pick a Calendar sheet will not work.

 

Step 6: Print the calendar or export to PDF

Excel’s default print menu options and Export options work as usual. If you are not familiar, it is not a problem. I explain them in detail with screenshots towards the end of this post.

 

 


17 CALENDAR DESIGNS

Let’s look at each of the 17 calendar designs.

2017 Calendar Designs
2017 Calendar Designs

 

Calendar Design 1

2017 Calendar Design 1 - 1 Page 12 Months - 4 X 3
2017 Calendar Design 1 – 1 Page 12 Months – 4 X 3

 

  • This design prints the entire year in 1 page.
  • The 12 months are shown in 4 rows X 3 columns.
  • The Holidays,¬†Events¬†and Weekends are¬†highlighted on the calendar.
  • Holiday Names and Event Names are not listed in this design.
  • There is a place¬†to enter any notes at the bottom of the page.

When both Event and Holiday fall on the same day, Event is prioritized and event color is displayed.

Calendar Design 2

2017 Calendar Design 2 - 1 Page 12 Months - 3 X 4
2017 Calendar Design 2 – 1 Page 12 Months – 3 X 4

 

  • This design prints the entire year in 1 page.
  • The 12 months are shown in 3¬†rows X 4 columns.
  • The Holidays,¬†Events¬†and Weekends are¬†highlighted on the calendar.
  • Holiday Names and Event Names are not listed in this design.
  • There is a place¬†to enter any notes at the bottom of the page.

 

Calendar Design 3

2017 Calendar Design 3 - 1 Page 12 Months - 2 X 6 with Events
2017 Calendar Design 3 – 1 Page 12 Months – 2 X 6 with Events

 

  • This design prints the entire year in 1 page.
  • The 12 months are shown in 2¬†rows X 6 columns.
  • The Holidays,¬†Events¬†and Weekends are¬†highlighted on the calendar.
  • 20 Holiday Names and 20 Event Names are listed in this design.

 

Calendar Design 4

2017 Calendar Design 4 - 1 Page 12 Months - 6 X 2 with Events
2017 Calendar Design 4 – 1 Page 12 Months – 6 X 2 with Events

 

  • This design prints the entire year in 1 page.
  • The 12 months are shown in 6 rows X 2 columns.
  • The Holidays,¬†Events¬†and Weekends are¬†highlighted on the calendar.
  • 20 Holiday Names and 30 Event Names are listed in this design.

 

Calendar Design 5

2017 Calendar Design 5 - 1 Page 12 Months - 12 X 42 with Events
2017 Calendar Design 5 – 1 Page 12 Months – 12 X 42 with Events

 

  • This design prints the entire year in 1 page.
  • The 12 months are shown in 12 rows X 42 columns.
  • The Holidays,¬†Events¬†and Weekends are¬†highlighted on the calendar.
  • 10 Holiday Names and 20 Event Names are listed in this design.

 

Calendar Design 6

2017 Calendar Design 6 - 1 Page 12 Months - 12 X 31 with Events
2017 Calendar Design 6 – 1 Page 12 Months – 12 X 31 with Events

 

  • This design prints the entire year in 1 page.
  • The 12 months are shown in 12 rows X 31 columns.
  • The Holidays,¬†Events¬†and Weekends are¬†highlighted on the calendar.
  • 10 Holiday Names and 20 Event Names are listed in this design.

 

Calendar Design 7

2017 Calendar Design 7 - 6 Pages - Planner
2017 Calendar Design 7 – 6 Pages – Planner

 

  • This design prints the entire year in 6 pages.
  • The 12 months are shown in 31¬†rows X 12 columns.
  • The Holidays,¬†Events¬†and Weekends are¬†highlighted on the calendar.
  • Holiday Names and Event Names are not¬†listed in this design.
  • Type notes directly next to each date on the calendar.

 

Calendar Design 8

2017 Calendar Design 8 - 1 Page - 54 Weeks - with Events
2017 Calendar Design 8 – 1 Page – 54 Weeks – with Events

 

  • This design prints the entire year in 1¬†page.
  • The 12 months are shown in 54 rows X 7¬†columns.
  • The Holidays and¬†Events¬†are not highlighted on the calendar.
  • 20 Holiday Names and 30 Event Names are listed in this design.

 

Calendar Design 9

2017 Calendar Design 9 - 12 Pages - Monthly
2017 Calendar Design 9 – 12 Pages – Monthly

 

  • This design prints the entire year in 12 pages.
  • The 12 months are shown as one month in each page and each month as 6 rows X 7 columns.
  • The Holidays,¬†Events¬†and Weekends are highlighted on the calendar.
  • Holiday Names and Event Names are not¬†listed in this design.

 

Calendar Design 10

2017 Calendar Design 10 - 6 Pages - with Events
2017 Calendar Design 10 – 6 Pages – with Events

 

  • This design prints the entire year in 6¬†pages.
  • The 12 months are shown as 2¬†months in each page and each month as 6 rows X 7 columns.
  • The Holidays,¬†Events¬†and Weekends are highlighted on the calendar.
  • 10 Holiday Names and 10 Event Names are listed¬†for each month in this design.

 

Calendar Design 11

2017 Calendar Design 11 - 4 Pages - with Events
2017 Calendar Design 11 – 4 Pages – with Events

 

  • This design prints the entire year in 4 pages.
  • The 12 months are shown as 3¬†months in each page and each month as 6 rows X 7 columns.
  • The Holidays,¬†Events¬†and Weekends are highlighted on the calendar.
  • 5 Holiday Names and 5 Event Names are listed¬†for each month in this design.

 

Calendar Design 12

2017 Calendar Design 12 - 3 Pages
2017 Calendar Design 12 – 3 Pages

 

  • This design prints the entire year in 3 pages.
  • The 12 months are shown as 4¬†months in each page and each month as 6 rows X 7 columns.
  • The Holidays,¬†Events¬†and Weekends are highlighted on the calendar.
  • Holiday Names and Event Names are not¬†listed¬†in this design.

 

Calendar Design 13

2017 Calendar Design 13 - 2 Pages - 6 Months on each page
2017 Calendar Design 13 – 2 Pages – 6 Months on each page

 

  • This design prints the entire year in 2 pages.
  • The 12 months are shown as 6 months in each page and each month as 6 rows X 7 columns.
  • The Holidays,¬†Events¬†and Weekends are highlighted on the calendar.
  • Holiday Names and Event Names are not¬†listed¬†in this design.

 

Calendar Design 14

2017 Calendar Design 14 - 12 Pages - Monthly - with Events
2017 Calendar Design 14 – 12 Pages – Monthly – with Events

 

  • This design prints the entire year in 12 pages.
  • The 12 months are shown as 1¬†month in each page and each month as 6 rows X 7 columns.
  • The Holidays,¬†Events¬†and Weekends are highlighted on the calendar.
  • Holiday Names and Event Names are listed¬†for each month in this design.

 

Calendar Design 15

2017 Calendar Design 15 - 12 Pages - Monthly - Type Events
2017 Calendar Design 15 – 12 Pages – Monthly – Type Events

 

  • This design prints the entire year in 12 pages.
  • The 12 months are shown as 1¬†month in each page and each month as 6 rows X 7 columns.
  • The Holidays,¬†Events¬†and Weekends are highlighted on the calendar.
  • Holiday Names and Event Names are not¬†listed¬†for each month in this design.
  • Type any text just below any date directly on the Calendar.

 

Calendar Design 16 (Picture Calendar)

2017 Calendar Design 16 - 12 Pages - Picture Calendar
2017 Calendar Design 16 – 12 Pages – Picture Calendar

 

  • This design prints the entire year in 12 pages.
  • The 12 months are shown as 1¬†month in each page and each month as 6 rows X 7 columns.
  • The Holidays,¬†Events¬†and Weekends are highlighted on the calendar.
  • Holiday Names and Event Names are not¬†listed¬†for each month in this design.
  • Right Click on image and change picture for each month.
Change picture in Picture calendar Choose from file on computer or online
Change picture in Picture calendar Choose from file on computer or online

 

Calendar Design 17 (Quotes Calendar)

2017 Calendar Design 17 - 12 Pages - Quotes Calendar
2017 Calendar Design 17 – 12 Pages – Quotes Calendar

 

  • This design prints the entire year in 12 pages.
  • The 12 months are shown as 1¬†month in each page and each month as 6 rows X 7 columns.
  • The Holidays,¬†Events¬†and Weekends are highlighted on the calendar.
  • Holiday Names and Event Names are not¬†listed¬†for each month in this design.
  • Click on placeholder text and type any text¬†for each month. Create your own customized calendar of quotes.

 


TIPS TO CUSTOMIZE THE CALENDAR TEMPLATE

1. How to change formatting (colors/fonts/borders)?

One of the common reasons for making changes would be to change the formatting of the calendar. I am sure that you may have your personal favorites when it comes to colors and fonts. The template is designed so that you can make these changes yourself without negatively affecting the functionality of the calendar.

Select the cells you want to change formatting.

Select Cells to change formatting
Select Cells to change formatting

 

For example, in the image above, I have selected the 2 months (January & February).

In the Home ribbon, you will see the Font section (as shown below).

How to change formatting on calendar (font, font size, font color, border, bold, italics)
How to change formatting on calendar (font, font size, font color, border, bold, italics)

We can change the font, font size, font color, fill color, borders and also apply bold and italics format.

For example, when I changed the font, applied bold text and reduced the font size, it appears like this.

Changes to font and font size and bold
Changes to font and font size and bold

 

Changed font and font size and bold
Changed font and font size and bold

 

Some of the border options require unprotecting the sheet. We will see how we can unprotect later in this post.

 

A couple of things to note here:

  • If you change the font color, the dates’ color will change except for the Weekends. Weekends are set up to show with red color.
  • If you change the fill color, you will notice that the days with Holidays and Events will not change. Holidays and Events are set up separately with their own colors.

I will explain now how both the above points can also be addressed.

 

2. How to change Event and Holiday colors?

Events and Holidays are colored automatically on the calendar¬†using conditional formatting. ¬†As with everything with this template, it’s easy to change them too.

First, click on Conditional Formatting menu in the Home ribbon, and select Manage Rules.

Open Conditional Formatting Menu
Open Conditional Formatting Menu

 

The next dialog box shows the 3 rules we have used in this worksheet. Make sure that you choose ‘This worksheet‘ at the top.

Three conditional formatting rules for Weekends Holidays and Events
Three conditional formatting rules for Weekends Holidays and Events

 

We can modify each of the rules separately. Just click on one of the rules and then click on ‘Edit Rule’ button.¬†In this example, I have clicked on the ‘Events’ rule.

Conditional formatting - Edit Format for a rule
Conditional formatting – Edit Format for a rule

 

Click on the Format button. It opens the next dialog box.

Conditional formatting - Change format for the Events dates cells
Conditional formatting – Change format for the Events dates cells

 

We can modify not just the fill color, but also the Number format, font and border. For this tutorial, I have just highlighted where you can change the background fill color.

You can choose one of the standard colors or click on ‘More Colors‘ button to choose any color from the spectrum.

Click OK to the dialog box and then the following open dialog boxes.

Then, you should see the changes applied to the entire calendar sheet. Save the file to save the changes.

 

3. How to change the order in which events/holidays appear on calendar?

Some of the calendar designs list the names of events and holidays on the calendar. They are designed to be listed in the same order in which they were entered in the Holidays and Events tables in Settings sheet.

If  you had entered them in a random order in the tables, then you can easily sort them. For example, in the Events table, click on the Event Date header label.

A menu pops up where you can choose ‘Sort Oldest to Newest‘.

Sort Events by Dates in Events table
Sort Events by Dates in Events table

 

This would sort the Events table with dates in ascending order.

You can apply the same technique to the Holidays table.

 

4. How to change the date format for events and holidays?

I have used the date format MMM-DD (example: Jan-05) to show the dates. I usually try to show the month in text instead of numbers as I understand that there are differences in formats used by different countries. 1/5 could be interpreted as Jan 5th or May 1st, depending on which country you live in.

However, you can easily change it to any format to suit your needs.

Just select the cells where you want to apply the change.

Then, press Ctrl+1 to open the Format cells dialog box.

Change date formats using Format cells option
Change date formats using Format cells option

 

You can type your own custom format or¬†click on ‘Date’ in the list on the left. Then, you can choose from the standard date formats.

Choose one from the standard date formats
Choose one from the standard date formats

 

5. How to unprotect (unlock) sheets?

All the customization mentioned above can be made without unprotecting any sheets. If you plan to make more modifications and you see that you are not able to, you can unprotect using indzara as password.

For more details, please see my article on how to unprotect sheets.

Please remember to protect the sheets again in order to prevent accidental editing of formulas.

6. How to print calendars?

To print, press Ctrl+P or find the Print option in the File menu.

Open Print settings with ctrl P
Open Print settings with ctrl P

Since the template is already pre-set for printing calendars, you can quickly review the calendar in preview and then click on Print to print.

If you need to print only a subset of pages, please enter page number range.

 

7. How to export calendar to PDF?

To export to PDF, choose Export in the File menu and then click on Create PDF/XPS.

Export calendars as PDF
Export calendars as PDF

In the following dialog box,

Publish Calendars as PDF options
Publish Calendars as PDF options
  1. Choose the place in your computer to store the PDF.
  2. Give a meaningful name to the PDF
  3. If you need to control which pages are being exported to PDF, click on Options. That will open the following window.

Exporting only some pages as PDF

Choose specific page numbers you want to export and click OK.

4. Click Publish to publish PDF.


RECOMMENDED TEMPLATE

Event Calendar Maker 

Additional Features in Event Calendar Maker
Additional Features in Event Calendar Maker

 

  • Works for any year
  • 300 events and 1200 instances
  • Categorize events into 12 Event Types
  • Choose from 15 Colors to highlight
  • 7 Calendar Designs (2 Yearly, 3 Monthly, Weekly and Daily calendars)
  • 12 Frequency Types (automatically generate recurring events)
  • Control which events you would like to display by deactivating events
  • Control order of priority of events
  • Switch Off Non-business days easily

I hope you find this sheet useful. Please share with your friends if you do.

Please leave a comment below to let me know your feedback. Thank you.

18 thoughts on “Excel Calendar Template – 17 Calendar Designs in Excel – Free Download

  1. Requesting addition of extra event categories. Currently there are only holidays and events. I need 3 or 4 categories in total (for example sick days, vacation, pto, holidays, etc)

    A count function would also be helpful, especially if it allowed for half days. This would allow for tracking of vacation hours and sick time.

    1. Thanks for using our template.

      This template is designed to provide various designs for your calendar, which will include holidays and events of your organization.
      For tracking employee leaves, PTO, vacation, etc, we have separate templates. Please visit https://indzara.com/shop/ for other templates.

      Best wishes

  2. Is it possible to show full holidays below the yearly calendar and disable events?

    1. Thanks for your message.

      Since this template allows customization, you may ignore the events altogether.

      Best wishes

  3. I cannot figure out why sometimes my events are published on the calendar, but sometimes they are not. Can you assist me?

    1. Hello

      Please email your file along with the list of issues to contact@indzara.com

      Regards

  4. I cannot get the calendar to display the date. I am using excel 2007. Ty

    1. Hello
      Thank you for your interest in our template.
      We have tested this template on Excel 2010 and above. Hence, cannot confirm if it will work on Excel 2007.
      Best regards

  5. Hi there! Fantastic resource, thank you so much for loading this.
    I’m trying to create a calendar for 2017 using template 1 with the weeks starting on a Saturday. When I do this the dates don’t fill in and I get left with a blank week. I was going to type them in by hand but the sheet is password protected so I cant. Can you help at all?

    1. Thank you.
      Can you please clarify whether you see a blank week as the first week? If so, which month? I tried it just now and everything populated as expected.
      Please email me file to support@indzara.com.
      Thanks & Best wishes.

  6. Hi there,

    This is a brilliant calendar. One question. Is it possible to add another column in the Settings Worksheet in the Events Table after the Event Name called “Owner” or “Contact Person” that would show in the calendars? What would be the formula?

    1. Actually, I figured out the formula,what I can’t figure out is how do I make the spaces between my new columns wider so the details of my events fit into the calendar entries where the events are listed. The columns are too narrow. How can I make it so the width applies to all sheets where events are listed

  7. I entered an event but does not appear in the calanred

    1. Please check whether the data is entered inside the table correctly. This is the most common reason.
      If there are further questions, please email the file to indzara@gmail.com.
      Best wishes.

  8. I did not hesitate to download your 2017 Calendar as I have used your ‘Event Calendar Maker’ in my workplace and found it to be very easy to set up and use. I know this new Calendar will assist me greatly.

    1. Thank you very much. I am glad to hear that you find the templates useful. Best wishes.

  9. Thank you so much!! You are great for giving this great format template.

    1. You are very welcome. I am glad you like it. Thanks for the feedback. Best wishes.

Leave a Reply

Your email address will not be published. Required fields are marked *