These are 2017 calendar templates created particularly to be used with Microsoft Excel. There are new models added in this year templates to give you more options on selecting the most suitable one with your needs. With these new models, you can now have option to set your event dates chronologically either they are single or consecutive dates. And, there are more rows to insert your consecutive dates as well, because you don’t have to switch columns or table to insert those dates.
Hopefully, these calendars could fit any types of your needs. But, not all new calendar templates are free. Some are available in commercial version, as their brief description can be read at the bottom of this article.
Here are all free 2017 calendar models.
Model 1 :
You might familiar with these ones. They are original calendar templates that have been here since 2008. There are 3 tables for single event dates and 3 tables for consecutive event dates. All event tables are in separate worksheet where all inputted event dates will be marked in respective dates inside the calendar in another worksheet.
2017 Calendar Templates Model 1 - V2.6 (1,009.3 KiB, 4,449 hits)
Model 2 :
This model is available since last year. It is a one page calendar where it has event description in the middle of the calendar. Single and consecutive tables are still separated in this model. But you can have similar color for those dates by typing similar color codes on respective dates.
2017 Calendar Templates Model 2 - V2.6 (595.1 KiB, 2,703 hits)
Model 3 :
This is a linear calendar. All dates are aligned horizontally. It has event description date tables with similar layout with model 1, but you can print this calendar and event table within one single page.
2017 Calendar Templates Model 3 - V2.6 (522.0 KiB, 2,589 hits)
Model 5 :
This is a new model. The first picture in this article is a screenshot of this model. It has month tables at the left side and event description at the right side. You can print its month table only or include its event description.
It has 42 event date rows where you can type single or consecutive dates in those rows. Select event month in column AA, and type single or consecutive start date in column AB. If you input single date, you can continue to the next row, but you need to type consecutive end date in column AD if you plan to cover several dates in sequence.
Those written dates will be marked with specific color in month tables. You can specify the color by typing the code in color code column (AG). There are dummy dates already inputted in this calendar to guide you type it properly. Due to lengthy conditional formatting formula, Sunday and Monday model is created in separate spreadsheet.
2017 Calendar Templates Model 5 - V2.6 (1,007.1 KiB, 1,444 hits)
Model 7 :
This is a linear model, like model 3, but it has sharing date features like model 5. All event date tables are grouped into specific months. If you want to add event that occur in February, you have to type it in February table. It has 8 rows that you can type with either single or consecutive dates. You can apply different color markers for all of those inputted dates. And you can hide the color codes by turn it off from the dropdown list at the right side of the calendar to make it hidden from the calendar when you print it.
2017 Calendar Templates Model 7 - V2.6 (1,018.0 KiB, 1,922 hits)
Model 8 :
This one basically has a similar model with model 3, except it has 3 rows in each month. Each row has one assigned single event and one assigned consecutive dates as you can see in each event table header title.
2017 Calendar Templates Model 8 - V2.6 (530.3 KiB, 1,692 hits)
Model 11 :
If you are looking previous calendar model with event description at the left and right side of the calendar, you can download this new model. It has similar outlook with previous one, except I modified its date columns to accommodate consecutive dates. Previously, you only can type single date in its event description. By having this consecutive dates option, you can type more dates in respective month description table.
2017 Calendar Templates Model 11 - V2.6 (1.0 MiB, 2,822 hits)
Model 13 :
This is a monthly version. No new additional functions. To use this calendar, you just have to put your dates in Event list worksheet and all dates will be populated automatically in respective month worksheets.
2017 Calendar Templates Model 13 - V2.7 (746.5 KiB, 3,592 hits)
Model 14 :
This calendar is similar with model 12, except you must type in each month worksheets where all dates and event description will be pulled into the table in Event list worksheet.
2017 Calendar Templates Model 14 - V2.6 (1,002.3 KiB, 1,418 hits)
As usual, all calendars above are protected, they can be used but they can’t be modified. And if you see model numbering above, you will see that some models are missing. They are not missing, they are just not available for free. You can read more about other models in About worksheet in each calendars.
Those 2017 calendars require a minimum Excel 2007 for Windows and Excel 2008 for Mac to make all conditional formatting formula run properly. You can purchase the commercial version for USD 5.00 only if you want to have full control over those 14 models.
2017 Calendar Templates – USD 5.00