2019 Yearly Calendar Template

  • Version
  • 3'750 Downloads
  • 1.1 MB File Size
  • January 1, 2019 Updated
  • 9 Number of comments
  • Yes Free
  • Rating

These are 2017, 2018 and 2019 calendar templates created particularly to be used with Microsoft Excel. There are new models added in those 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.

2017 Calendar Template Model 5

Hopefully, these calendars could fit any types of your needs. But, not all new calendar templates are free. Some are available in commercial version where you can read brief descriptions of those in About worksheet in each calendars.

Here are all free 2017 and 2018 calendar models.

Model 1

2017 Calendar Template Model 1You 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.

Model 2

2017 Calendar Template Model 2This model is available since last year. It is a one page calendar where it has event description in the middle of the calendar. Event with single dates is at the above part of the calendar while event with date period is at the bottom part. But you can have similar color for those dates by typing similar color codes on respective dates.

Model 3

2017 Calendar Template Model 3This 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.

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.

Model 7

2017 Calendar Template Model 7This 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.

Model 8

2017 Calendar Template Model 8This 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.

Model 11

2017 Calendar Template Model 11If 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.

Model 13

2017 Calendar Template Model 13This is a monthly version. No new additional functions. To use this calendar, you need to put all of your dates and event descriptions in Event list worksheet. The Excel formulas in all month worksheets will populate those data into respective date boxes in each month worksheet. You can put until 6 events in each date boxes.

Model 14

This calendar is similar with model 13, except you must type all event descriptions in each month worksheets. Event table in the first worksheet will pull and sort those data into one long list. This calendar fits with you who want to scratch the plan inside the calendar directly. Then, print it into a list to remind you the dates.

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 and 2018 calendar templates 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 for 2017 Calendars and 15 models for 2018 Calendars.

If you are looking for event calendar that cover half of 2017 months and half of 2018 months, usually for creating school calendars, you read more about it here.

There is one new model in 2018 calendar packages. It has Gantt Chart look alike view. You can type your events and its date period at the left side. Then, the formula will mark those dates into respective dates at the right side.

You can download unprotected calendar templates for 2019 here.

How useful was this template?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry 🙁

Help us improve!

Portrait Calendar

250 Kb / 586 downloads
Event Calendar Template

840 Kb / 519 downloads
Holiday and Observance Calendar

37 KB / 607 downloads
Calendar Chart

61 KB / 471 downloads
2019 Academic Calendar Templates

6.7 MB / 14809 downloads
Monthly Event Calendar

149 KB / 1321 downloads
Chinese Calendar 2019

26 KB / 9430 downloads
View Comments