Band Calendar
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
Comment only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAK
1
Holidays and Events
© 2015 Vertex42 LLC
2018Next MonthJanuary
2
JanuaryJanuaryFebruary
3
FebruaryFebruary
This worksheet uses formulas to calculate the dates for various holidays and observances. If you want to enter dates for events
Special Formula
March
4
MarchMarch
without using formulas or cell references, just enter the description in column A and the date in column G. When adding new
Specific DatesApril
5
AprilApril
rows, copy the formulas down in columns H through L. These extra columns allow the monthly calendar to list multiple events per day.
Other Specific Events
May
6
MayMay
To add events that update based on the year, enter =$B$10 in the year column. For calendars spanning two years (like school calendars),
Other EventsJune
7
JuneJune
add the same event on two rows, entering =$B$10+1 in the year column for the second row.
July
8
JulyJulyAugust
9
AugustAugustSeptember
10
SeptemberSeptemberYear:2018October
11
OctoberOctober
12
NovemberNovember
13
DecemberDecemberNovember
14
Dates that use special formulas
DecemberCOPY TO CSV File To upload to Google Calendar
15
DateHolidayColumn DisplayYearMonthDayWeekWeekday1st Event2nd Event3rd Event4th Event5th Event6th EventDay of weekVacation HoursWeek NumberComments
Who / What / Subject
Start DateStart TimeEnd TimeAll Day EventDescriptionLocationPrivateCombined DateWhoWhenWhereAddressCityStateZip codeEmail Data
16
12/25/17ML King DayHoliday201810212/25/17 - - - - - Monday52ML King Day12/25/2017FALSETRUEML King Day
ML King Day


,
Stop Time 12:00 AM
17
1/21/19ML King DayHoliday20191321/21/19 - - - - - Monday4ML King Day1/21/2019FALSETRUEML King Day
ML King Day


,
Stop Time 12:00 AM
18
2/19/18Presidents' DayHoliday20182322/19/18 - - - - - Monday8Presidents' Day2/19/2018FALSETRUEPresidents' Day
Presidents' Day


,
Stop Time 12:00 AM
19
2/18/19Presidents' DayHoliday20192322/18/19 - - - - - Monday8Presidents' Day2/18/2019FALSETRUEPresidents' Day
Presidents' Day


,
Stop Time 12:00 AM
20
5/13/18Mother's DayHoliday20185215/13/18 - - - - - Sunday20Mother's Day5/13/2018FALSETRUEMother's Day
Mother's Day


,
Stop Time 12:00 AM
21
5/12/19Mother's DayHoliday20195215/12/19 - - - - - Sunday20Mother's Day5/12/2019FALSETRUEMother's Day
Mother's Day


,
Stop Time 12:00 AM
22
6/17/18Father's DayHoliday20186316/17/18 - - - - - Sunday25Father's Day6/17/2018FALSETRUEFather's Day
Father's Day


,
Stop Time 12:00 AM
23
6/16/19Father's DayHoliday20196316/16/19 - - - - - Sunday25Father's Day6/16/2019FALSETRUEFather's Day
Father's Day


,
Stop Time 12:00 AM
24
5/28/18Memorial DayHoliday20186025/28/18 - - - - - Monday22Memorial Day5/28/2018FALSETRUEMemorial Day
Memorial Day


,
Stop Time 12:00 AM
25
5/27/19Memorial DayHoliday20196025/27/19 - - - - - Monday22Memorial Day5/27/2019FALSETRUEMemorial Day
Memorial Day


,
Stop Time 12:00 AM
26
9/3/18Labor DayHoliday20189129/3/18 - - - - - Monday36Labor Day9/3/2018FALSETRUELabor Day
Labor Day


,
Stop Time 12:00 AM
27
9/2/19Labor DayHoliday20199129/2/19 - - - - - Monday36Labor Day9/2/2019FALSETRUELabor Day
Labor Day


,
Stop Time 12:00 AM
28
11/22/18ThanksgivingHoliday2018114511/22/18 - - - - - Thursday47Thanksgiving11/22/2018FALSETRUEThanksgiving
Thanksgiving


,
Stop Time 12:00 AM
29
11/28/19ThanksgivingHoliday2019114511/28/19 - - - - - Thursday48Thanksgiving11/28/2019FALSETRUEThanksgiving
Thanksgiving


,
Stop Time 12:00 AM
30
11/23/18Black FridayHoliday20181111/23/18 - - - - - Friday47Black Friday11/23/2018FALSETRUEBlack Friday
Black Friday


,
Stop Time 12:00 AM
31
11/29/19Black FridayHoliday20191111/29/19 - - - - - Friday48Black Friday11/29/2019FALSETRUEBlack Friday
Black Friday


,
Stop Time 12:00 AM
32
3/11/18Daylight SavingHoliday2018413/11/18 - - - - - Sunday11Daylight Saving3/11/2018FALSETRUEDaylight Saving
Daylight Saving


,
Stop Time 12:00 AM
33
3/10/19Daylight SavingHoliday2019413/10/19 - - - - - Sunday11Daylight Saving3/10/2019FALSETRUEDaylight Saving
Daylight Saving


,
Stop Time 12:00 AM
34
11/4/18Daylight SavingHoliday201811111/4/18 - - - - - Sunday45Daylight Saving11/4/2018FALSETRUEDaylight Saving
Daylight Saving


,
Stop Time 12:00 AM
35
11/3/19Daylight SavingHoliday201911111/3/19 - - - - - Sunday45Daylight Saving11/3/2019FALSETRUEDaylight Saving
Daylight Saving


,
Stop Time 12:00 AM
36
4/1/18EasterHoliday20184/1/18 - - - - - Sunday14Easter4/1/2018FALSETRUEEaster
Easter


,
Stop Time 12:00 AM
37
4/21/19EasterHoliday20194/21/19 - - - - - Sunday17Easter4/21/2019FALSETRUEEaster
Easter


,
Stop Time 12:00 AM
38
3/30/18Good FridayHolidayEaster -33/30/18 - - - - - Friday13Good Friday3/30/2018FALSETRUEGood Friday
Good Friday


,
Stop Time 12:00 AM
39
4/19/19Good FridayHolidayEaster -34/19/19 - - - - - Friday16Good Friday4/19/2019FALSETRUEGood Friday
Good Friday


,
Stop Time 12:00 AM
40
3/20/18Spring BeginsHoliday20183/20/18 - - - - - Tuesday12Spring Begins3/20/2018FALSETRUESpring Begins
Spring Begins


,
Stop Time 12:00 AM
41
3/20/19Spring BeginsHoliday20193/20/19 - - - - - Wednesday12Spring Begins3/20/2019FALSETRUESpring Begins
Spring Begins


,
Stop Time 12:00 AM
42
6/21/18Summer BeginsHoliday20186/21/18 - - - - - Thursday25
Summer Begins
6/21/2018FALSETRUE
Summer Begins
Summer Begins


,
Stop Time 12:00 AM
43
6/21/19Summer BeginsHoliday20196/21/19 - - - - - Friday25
Summer Begins
6/21/2019FALSETRUE
Summer Begins
Summer Begins


,
Stop Time 12:00 AM
44
9/23/18Fall BeginsHoliday20189/23/18 - - - - - Sunday39Fall Begins9/23/2018FALSETRUEFall Begins
Fall Begins


,
Stop Time 12:00 AM
45
9/23/19Fall BeginsHoliday20199/23/19 - - - - - Monday39Fall Begins9/23/2019FALSETRUEFall Begins
Fall Begins


,
Stop Time 12:00 AM
46
12/21/18Winter BeginsHoliday201812/21/18 - - - - - Friday51Winter Begins12/21/2018FALSETRUEWinter Begins
Winter Begins


,
Stop Time 12:00 AM
47
12/22/19Winter BeginsHoliday201912/22/19 - - - - - Sunday52Winter Begins12/22/2019FALSETRUEWinter Begins
Winter Begins


,
Stop Time 12:00 AM
48
Holidays and Observances on a Specific Day of the Year
49
DateHolidayColumn DisplayYearMonthDayWeekWeekday1st Event2nd Event3rd Event4th Event5th Event6th EventDay of weekVacation HoursWeek NumberComments
Who / What / Subject
Start DateStart TimeEnd TimeAll Day EventDescriptionLocationPrivateCombined DateWhoWhenWhereAddressCityStateZip codeEmail Data
50
1/1/2018New Year's DayHoliday2018111/1/18 - - - - - Monday1New Year's Day1/1/2018FALSETRUENew Year's Day
New Year's Day


,
Stop Time 12:00 AM
51
1/1/2019New Year's DayHoliday2019111/1/19 - - - - - Tuesday1New Year's Day1/1/2019FALSETRUENew Year's Day
New Year's Day


,
Stop Time 12:00 AM
52
2/14/2018Valentine's DayHoliday20182142/14/18 - - - - - Wednesday7Valentine's Day2/14/2018FALSETRUEValentine's Day
Valentine's Day


,
Stop Time 12:00 AM
53
2/14/2019Valentine's DayHoliday20192142/14/19 - - - - - Thursday7Valentine's Day2/14/2019FALSETRUEValentine's Day
Valentine's Day


,
Stop Time 12:00 AM
54
3/17/2018St. Patrick's DayHoliday20183173/17/18 - - - - - Saturday11
St. Patrick's Day
3/17/2018FALSETRUE
St. Patrick's Day
St. Patrick's Day


,
Stop Time 12:00 AM
55
3/17/2019St. Patrick's DayHoliday20193173/17/19 - - - - - Sunday12
St. Patrick's Day
3/17/2019FALSETRUE
St. Patrick's Day
St. Patrick's Day


,
Stop Time 12:00 AM
56
4/1/2018April Fool's DayHoliday2018414/1/184/1/18 - - - - Sunday14April Fool's Day4/1/2018FALSETRUEApril Fool's Day
April Fool's Day


,
Stop Time 12:00 AM
57
4/1/2019April Fool's DayHoliday2019414/1/19 - - - - - Monday14April Fool's Day4/1/2019FALSETRUEApril Fool's Day
April Fool's Day


,
Stop Time 12:00 AM
58
7/4/2018Independence DayHoliday2018747/4/18 - - - - - Wednesday27
Independence Day
7/4/2018FALSETRUE
Independence Day
Independence Day


,
Stop Time 12:00 AM
59
7/4/2019Independence DayHoliday2019747/4/19 - - - - - Thursday27
Independence Day
7/4/2019FALSETRUE
Independence Day
Independence Day


,
Stop Time 12:00 AM
60
10/31/2018HalloweenHoliday2018103110/31/18 - - - - - Wednesday44Halloween10/31/2018FALSETRUEHalloween
Halloween


,
Stop Time 12:00 AM
61
10/31/2019HalloweenHoliday2019103110/31/19 - - - - - Thursday44Halloween10/31/2019FALSETRUEHalloween
Halloween


,
Stop Time 12:00 AM
62
11/11/2018Veterans DayHoliday2018111111/11/18 - - - - - Sunday46Veterans Day11/11/2018FALSETRUEVeterans Day
Veterans Day


,
Stop Time 12:00 AM
63
11/11/2019Veterans DayHoliday2019111111/11/19 - - - - - Monday46Veterans Day11/11/2019FALSETRUEVeterans Day
Veterans Day


,
Stop Time 12:00 AM
64
12/24/2018Christmas EveHoliday2018122412/24/18 - - - - - Monday52Christmas Eve12/24/2018FALSETRUEChristmas Eve
Christmas Eve


,
Stop Time 12:00 AM
65
12/24/2019Christmas EveHoliday2019122412/24/19 - - - - - Tuesday52Christmas Eve12/24/2019FALSETRUEChristmas Eve
Christmas Eve


,
Stop Time 12:00 AM
66
12/25/2018Christmas DayHoliday2018122512/25/18 - - - - - Tuesday52Christmas Day12/25/2018FALSETRUEChristmas Day
Christmas Day


,
Stop Time 12:00 AM
67
12/25/2019Christmas DayHoliday2019122512/25/19 - - - - - Wednesday52Christmas Day12/25/2019FALSETRUEChristmas Day
Christmas Day


,
Stop Time 12:00 AM
68
12/26/2018Day After ChristmasHoliday2018122612/26/18 - - - - - Wednesday52
Day After Christmas
12/26/2018FALSETRUE
Day After Christmas
Day After Christmas


,
Stop Time 12:00 AM
69
12/26/2019Day After ChristmasHoliday2019122612/26/19 - - - - - Thursday52
Day After Christmas
12/26/2019FALSETRUE
Day After Christmas
Day After Christmas


,
Stop Time 12:00 AM
70
12/31/2018New Year's EveHoliday2018123112/31/18 - - - - - Monday53New Year's Eve12/31/2018FALSETRUENew Year's Eve
New Year's Eve


,
Stop Time 12:00 AM
71
12/31/2019New Year's EveHoliday2019123112/31/19 - - - - - Tuesday53New Year's Eve12/31/2019FALSETRUENew Year's Eve
New Year's Eve


,
Stop Time 12:00 AM
72
- - - - - FALSETRUE



,
Stop Time 12:00 AM
73
FALSETRUE



,
Stop Time 12:00 AM
74
- - - - -



,
Stop Time 12:00 AM
75
For Dates such as "First Monday in September"
Other Events on a Specific Day of the Week



,
Stop Time 12:00 AM
76
DateEventColumn DisplayYearMonthDayWeekWeekday1st Event2nd Event3rd Event4th Event5th Event6th EventDay of weekVacation HoursWeek NumberComments
Who / What / Subject
Start DateStart TimeEnd TimeAll Day EventDescriptionLocationPrivateCombined DateWhoWhenWhereAddressCityStateZip codeEmail Data
77
6/5/18MeetingBand Booster20186136/5/18 - - - - - Tuesday23Meeting6/5/20187:30:00 PM9:00:00 PMTRUETRUEMeeting6/5/2018 19:30:00
Meeting


,
Stop Time 9:00 PM
78
7/3/18MeetingBand Booster20187137/3/18 - - - - - Tuesday27Meeting7/3/20187:30:00 PM9:00:00 PMTRUETRUEMeeting7/3/2018 19:30:00
Meeting


,
Stop Time 9:00 PM
79
8/7/18MeetingBand Booster20188138/7/18 - - - - - Tuesday32Meeting8/7/20187:30:00 PM9:00:00 PMTRUETRUEMeeting8/7/2018 19:30:00
Meeting


,
Stop Time 9:00 PM
80
9/4/18MeetingBand Booster20189139/4/18 - - - - - Tuesday36Meeting9/4/20187:30:00 PM9:00:00 PMTRUETRUEMeeting9/4/2018 19:30:00
Meeting


,
Stop Time 9:00 PM
81
10/2/18MeetingBand Booster2018101310/2/18 - - - - - Tuesday40Meeting10/2/20187:30:00 PM9:00:00 PMTRUETRUEMeeting10/2/2018 19:30:00
Meeting


,
Stop Time 9:00 PM
82
11/6/18MeetingBand Booster2018111311/6/18 - - - - - Tuesday45Meeting11/6/20187:30:00 PM9:00:00 PMTRUETRUEMeeting11/6/2018 19:30:00
Meeting


,
Stop Time 9:00 PM
83
12/4/18MeetingBand Booster2018121312/4/18 - - - - - Tuesday49Meeting12/4/20187:30:00 PM9:00:00 PMTRUETRUEMeeting12/4/2018 19:30:00
Meeting


,
Stop Time 9:00 PM
84
1/1/19MeetingBand Booster20191131/1/191/1/19 - - - - Tuesday1Meeting1/1/20197:30:00 PM9:00:00 PMTRUETRUEMeeting1/1/2019 19:30:00
Meeting


,
Stop Time 9:00 PM
85
2/5/19MeetingBand Booster20192132/5/19 - - - - - Tuesday6Meeting2/5/20197:30:00 PM9:00:00 PMTRUETRUEMeeting2/5/2019 19:30:00
Meeting


,
Stop Time 9:00 PM
86
3/5/19MeetingBand Booster20193133/5/19 - - - - - Tuesday10Meeting3/5/20197:30:00 PM9:00:00 PMTRUETRUEMeeting3/5/2019 19:30:00
Meeting


,
Stop Time 9:00 PM
87
10/1/19MeetingBand Booster2019101310/1/19 - - - - - Tuesday40Meeting10/1/20197:30:00 PM9:00:00 PMTRUETRUEMeeting10/1/2019 19:30:00
Meeting


,
Stop Time 9:00 PM
88
4/2/19MeetingBand Booster20194134/2/19 - - - - - Tuesday14Meeting4/2/20197:30:00 PM9:00:00 PMTRUETRUEMeeting4/2/2019 19:30:00
Meeting


,
Stop Time 9:00 PM
89
5/7/19MeetingBand Booster20195135/7/19 - - - - - Tuesday19Meeting5/7/20197:30:00 PM9:00:00 PMTRUETRUEMeeting5/7/2019 19:30:00
Meeting


,
Stop Time 9:00 PM
90
6/4/19MeetingBand Booster20196136/4/19 - - - - - Tuesday23Meeting6/4/20197:30:00 PM9:00:00 PMTRUETRUEMeeting6/4/2019 19:30:00
Meeting


,
Stop Time 9:00 PM
91
7/2/19MeetingBand Booster20197137/2/19 - - - - - Tuesday27Meeting7/2/20197:30:00 PM9:00:00 PMTRUETRUEMeeting7/2/2019 19:30:00
Meeting


,
Stop Time 9:00 PM
92
4/3/18Band BoosterSchool20184134/3/18 - - - - - Tuesday14Band Booster4/3/20187:30:00 PM9:00:00 PMTRUETRUEBand Booster4/3/2018 19:30:00
Band Booster


,
Stop Time 9:00 PM
93
(Useful for birthdays and anniversaries)
Other Events on a Specific Day of the Year
94
DateHolidayColumn DisplayYearMonthDayWeekWeekday1st Event2nd Event3rd Event4th Event5th Event6th EventDay of weekVacation HoursWeek NumberComments
Who / What / Subject
Start DateStart TimeEnd TimeAll Day EventDescriptionLocationPrivateCombined DateWhoWhenWhereAddressCityStateZip codeEmail Data
95
6/26/2018Optional PracticeMarching20186266/26/18 - - - - - Tuesday26
Optional Practice
6/26/20185:00:00 PM8:00:00 PMTRUETRUE
Optional Practice
6/26/2018 17:00:00
Optional Practice


,
Stop Time 8:00 PM
96
6/28/2018Optional PracticeMarching20186286/28/18 - - - - - Thursday26
Optional Practice
6/28/20185:00:00 PM8:00:00 PMTRUETRUE
Optional Practice
6/28/2018 17:00:00
Optional Practice


,
Stop Time 8:00 PM
97
7/2/2018Optional PracticeMarching2018727/2/18 - - - - - Monday27
Optional Practice
7/2/20185:00:00 PM8:00:00 PMTRUETRUE
Optional Practice
7/2/2018 17:00:00
Optional Practice


,
Stop Time 8:00 PM
98
7/7/2018Optional PracticeMarching2018777/7/18 - - - - - Saturday27
Optional Practice
7/7/20185:00:00 PM8:00:00 PMTRUETRUE
Optional Practice
7/7/2018 17:00:00
Optional Practice


,
Stop Time 8:00 PM
99
7/10/2018Booster MeetingBand Booster20187107/10/18 - - - - - Tuesday28
Booster Meeting
7/10/20187:30:00 PM9:00:00 PMTRUETRUE
Booster Meeting
7/10/2018 19:30:00
Booster Meeting


,
Stop Time 9:00 PM
100
7/14/2018John Paulding Days ParadeMarching20187147/14/18 - - - - - Saturday28
John Paulding Days Parade
7/14/2018FALSETRUE
John Paulding Days Parade
John Paulding Days Parade


,
Stop Time 12:00 AM
Loading...