Weekly Calendar with Holidays

  • Version
  • 48'847 Downloads
  • 41 KB File Size
  • October 26, 2009 Updated
  • 1 Number of comments
  • Yes Free
  • Rating
table of content

Completing my calendar templates that are created with monthly and yearly layouts, this weekly calendar is a calendar with weekly layout. And different than monthly calendar that only can have maximum 3 events to be displayed automatically based on event list, this weekly calendar can display until maximum 20 events. So, you can type your events in event list column and see them in your calendar based on your setup.

Weekly Calendar

There are two worksheets in this template, the first one is the Event and holidays worksheet where you can put your events and customize your holidays. On the event list, just type your event time and description and you don't have to sort the event based on your dates. Because the formula in other worksheet will find all the corresponding dates in the list to be displayed.

There is a holidays list in this worksheet where you can customize your holiday to be displayed in the calendar. But, there is only one holiday date that will appear in the calendar. So, if there are two or more holidays are on the same date, the formula will take the first created one.

Weekly Calendar Setup

The second worksheet is the Weekly calendar worksheet where you can see the calendar filled with your events. There is a start date box where you have to fill the reference date for the slider bar. Once you fill the date, you can slide right to change the start date of your weekly calendar and slide left to go back to the original date.

This calendar will display maximum 20 events and 1 holiday, and will turn the cell color of holiday date into red. I have also created several styles of weekly calendar for several purposes that should be useful for your daily and weekly schedules and activities, like class schedule, tv schedules and others. I will post them in my next posts.

How useful was this template?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry 🙁

Help us improve!

Holiday and Observance Calendar

37 KB / 91 downloads
Calendar Chart

61 KB / 77 downloads
Weekly Attendance Sheet

14 KB / 330 downloads
Training Attendance Sheet

13 KB / 374 downloads
Sunday School Attendance Sheet

27 KB / 307 downloads
Monthly Attendance Sheet

18 KB / 423 downloads
Meeting Attendance Sheet

13 KB / 416 downloads
Homeschool Attendance Sheet

16 KB / 355 downloads
View Comments