Spreadsheet: 672540d1586899858-reserve-calendar-days-row-for-holidays-only-zeszyt4
Sheet: Events

 |  |  |  | Holidays and Events
 | Year: | 2020
 | Start Month: | 1 |  | This worksheet uses formulas to calculate the dates for various holidays and observances. If you want to enter dates for events
 | Start Day: | 1 | 1:Sun,2:Mon | without using formulas or cell references, just enter the description in column A and the date in column G. When adding new
 |  |  |  | rows, copy the formulas down in columns H through L. These extra columns allow the monthly calendar to list multiple events per day.
 |  |  |  | To add events that update based on the year, enter =$N$3 in the year column. For calendars spanning two years (like school calendars),
 |  |  |  | add the same event on two rows, entering =$N$3+1 in the year column for the second row.
 |  |  |  | Dates that use special formulas
 |  |  |  | Holiday | Year | Month | Day | Week | Weekday | Date | 2nd Event | 3rd Event | 4th Event | 5th Event | 6th Event
 |  |  |  | ML King Day |  | 1 |  | 3 | 2
 |  |  |  | Presidents' Day |  | 2 |  | 3 | 2
 |  |  |  | Mother's Day |  | 5 |  | 2 | 1
 |  |  |  | Armed Forces Day |  | 5 |  | 3 | 7
 |  |  |  | Father's Day |  | 6 |  | 3 | 1
 |  |  |  | Memorial Day |  | 6 |  | 0 | 2
 |  |  |  | Parents' Day |  | 7 |  | 4 | 1
 |  |  |  | Labor Day |  | 9 |  | 1 | 2
 |  |  |  | Columbus Day |  | 10 |  | 2 | 2
 |  |  |  | Thanksgiving |  | 11 |  | 4 | 5
 |  |  |  | Taxes Due |  | 4
 |  |  |  | Daylight Saving |  | 4 |  |  | 1
 |  |  |  | Daylight Saving |  | 11 |  |  | 1
 |  |  |  | Grandparents Day
 |  |  |  | Admin Assist Day |  | 4 |  |  | 4
 |  |  |  | Chinese New Year
 |  |  |  | Easter
 |  |  |  | Good Friday | relative to Easter
 |  |  |  | Holidays and Observances on a Specific Day of the Year
 |  |  |  | Holiday | Year | Month | Day |  |  | Date
 |  |  |  | New Year's Day |  | 1 | 1
 |  |  |  | Groundhog Day |  | 2 | 2
 |  |  |  | Lincoln's B-Day |  | 2 | 12
 |  |  |  | [NAME]'s Day |  | 2 | 14
 |  |  |  | St. Patrick's Day |  | 3 | 17
 |  |  |  | April Fool's Day |  | 4 | 1
 |  |  |  | Earth Day |  | 4 | 22
 |  |  |  | Cinco de Mayo |  | 5 | 5
 |  |  |  | Flag Day |  | 6 | 14
 |  |  |  | Independence Day |  | 7 | 4
 |  |  |  | Aviation Day |  | 8 | 19
 |  |  |  | Patriot Day |  | 9 | 11
 |  |  |  | Constitution Day |  | 9 | 17
 |  |  |  | Boss's Day |  | 10 | 16
 |  |  |  | United Nations Day |  | 10 | 24
 |  |  |  | Halloween |  | 10 | 31
 |  |  |  | Veterans Day |  | 11 | 11
 |  |  |  | Pearl Harbor |  | 12 | 7
 |  |  |  | Christmas Eve |  | 12 | 24
 |  |  |  | Christmas Day |  | 12 | 25
 |  |  |  | New Year's Eve |  | 12 | 31
 |  |  |  | Other Events on a Specific Day of the Year |  |  |  |  |  | (Useful for birthdays, anniversaries, and appointments)
 | Cust ID | Job # | Details | Event | Year | Month | Day | Start | Hours | Date
 | MJ101 |  | home maintenance |  |  | 1 | 2 | 07:00:00 | 6
 | FF102 |  | yard work |  |  | 1 | 3 | 08:00:00 | 5
 | JJ103 |  | pressure washing |  |  | 1 | 4 | 07:00:00 | 2.5
 | HT104 |  | paint barn |  |  | 1 | 4 | 10:00:00 | 5
 | MJ101 |  | clean garage |  |  | 1 | 6 | 08:30:00 | 2
 | FF102 |  | cut grass |  |  | 12 | 25 | 09:00:00 | 1
 | XT105 |  | trim hedges |  |  |  |  |  | 1.5
 | AB106 |  | repair doors |  |  |  |  |  | 3