2020 Yearly Calendar Template
- 6'819 Downloads
- 3.6 MB File Size
- February 1, 2020 Updated
- 10 Number of comments
These are 2020 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.
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 2020 calendar models.
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.
This 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.
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.
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.
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.
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.
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.
This 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.
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 2020 calendar templates require a minimum Excel 2007 for Windows and Excel 2008 for Mac to make all conditional formatting formula run properly.
If you are looking for event calendar that cover half of months, usually for creating school calendars, you read more about it here.
There is one new model in 2020 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.
We are sorry 🙁
Help us improve!
How we can improve this template?