Spreadsheet: 796744d1663499584-formula-calendar-loses-values-when-year-is-changed-schedule
Sheet: Input

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALENDAR |  |  |  |  |  |  |  | INPUTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  | Calendar Year |  | 2022
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Su | Mo | [NAME] | We | Th | Fr | Sa |  | Days per visit: | 4
 |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days off: | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | First Day of Season |  | 2022-06-04 00:00:00
 |  |  |  |  |  | Date In |  | Party | Date Out |  |  |  | Date in |  | Party | Date Out |  |  |  |  |  |  |  |  |  |  |  |  | Dam Camp Closing Date: |  | 2022-08-14 00:00:00
 |  |  |  |  |  |  |  | Dysart | 2022-06-08 00:00:00 |  |  |  |  |  | Eddy | 2022-06-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Adams Camp Closing Date: |  | 2022-09-14 00:00:00
 |  |  |  |  |  |  |  | DAY OFF | 2022-06-09 00:00:00 |  |  |  |  |  | DAY OFF | 2022-06-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Reduced Days | 3 | 2022-08-10 00:00:00
 |  |  |  |  |  |  |  | Brice | 2022-06-13 00:00:00 |  |  |  |  |  | Brice | 2022-06-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-09-02 00:00:00
 |  |  |  |  |  |  |  | McAvity | 2022-06-17 00:00:00 |  |  |  |  | Tue | McAvity | 2022-06-21 00:00:00
 |  |  |  |  |  |  |  | DAY OFF | 2022-06-18 00:00:00 |  |  |  |  | Sat | DAY OFF | 2022-06-22 00:00:00 |  |  |  |  | June
 |  |  |  |  |  |  |  | Jobe | 2022-06-22 00:00:00 |  |  |  |  | Sun | Kenny | 2022-06-26 00:00:00 |  |  |  |  | Su | Mo | [NAME] | We | Th | Fr | Sa
 |  |  |  |  |  |  |  | Montgomery | 2022-06-26 00:00:00 |  |  |  |  | Thu | Montgomery | 2022-06-30 00:00:00
 |  |  |  |  |  |  |  | DAY OFF | 2022-06-27 00:00:00 |  |  |  |  | Mon | DAY OFF | 2022-07-01 00:00:00
 |  |  |  |  |  |  |  | [NAME] | 2022-07-01 00:00:00 |  |  |  |  | Tue | [NAME] | 2022-07-05 00:00:00
 |  |  |  |  |  |  |  | J Flemming | 2022-07-05 00:00:00 |  |  |  |  | Fri | Jobe | 2022-07-08 00:00:00
 |  |  |  |  |  |  |  | DAY OFF | 2022-07-06 00:00:00 |  |  |  |  | Tue | DAY(S)OFF | 2022-07-10 00:00:00
 |  |  |  |  |  |  |  | Open | 2022-07-10 00:00:00 |  |  |  |  | Wed | Spicer | 2022-07-14 00:00:00
 |  |  |  |  |  |  |  | Open | 2022-07-14 00:00:00 |  |  |  |  | Sun | [NAME] | 2022-07-18 00:00:00
 |  |  |  |  |  |  |  | DAY OFF | 2022-07-15 00:00:00 |  |  |  |  | Thu | DAY OFF | 2022-07-19 00:00:00 |  |  |  |  | July
 |  |  |  |  |  |  |  | [NAME] | 2022-07-19 00:00:00 |  |  |  |  | Fri | [NAME] | 2022-07-23 00:00:00 |  |  |  |  | Su | Mo | [NAME] | We | Th | Fr | Sa
 |  |  |  |  |  |  |  | Crane | 2022-07-23 00:00:00 |  |  |  |  | Tue | Crane | 2022-07-27 00:00:00
 |  |  |  |  |  |  |  | DAY OFF | 2022-07-24 00:00:00 |  |  |  |  | Sat | DAY OFF | 2022-07-28 00:00:00
 |  |  |  |  |  |  |  | Open | 2022-07-28 00:00:00 |  |  |  |  | Sun | T Flemming | 2022-08-01 00:00:00
 |  |  |  |  |  |  |  | Open | 2022-08-01 00:00:00 |  |  |  |  | Mon | Open | 2022-08-05 00:00:00
 |  |  |  |  |  |  |  | DAY OFF | 2022-08-02 00:00:00 |  |  |  |  | Tue | DAY OFF | 2022-08-06 00:00:00
 |  |  |  |  |  |  |  | Open | 2022-08-06 00:00:00 |  |  |  |  | Fri | Open | 2022-08-10 00:00:00
 |  |  |  |  |  |  |  | DAY OFF | 2022-08-07 00:00:00 |  |  |  |  | Sat | DAY OFF | 2022-08-11 00:00:00
 |  |  |  |  |  |  |  | Open | 2022-08-11 00:00:00 |  |  |  |  | Wed | DAY OFF | 2022-08-12 00:00:00 |  |  |  |  | August
 |  |  |  |  |  |  |  | Open | 2022-08-14 00:00:00 |  |  |  |  | Thu | Open | 2022-08-15 00:00:00 |  |  |  |  | Su | Mo | [NAME] | We | Th | Fr | Sa
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mon | Open | 2022-08-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Thu | DAY OFF | 2022-08-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Fri | Eddy | 2022-08-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sat | DAY OFF | 2022-08-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Tue | Open | 2022-08-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Fri | Reynolds | 2022-08-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sat | DAY OFF | 2022-08-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Tue | DAY OFF | 2022-09-01 00:00:00 |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Fri | Spicer | 2022-09-05 00:00:00 |  |  |  |  | Su | Mo | [NAME] | We | Th | Fr | Sa
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sat | [NAME] | 2022-09-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Tue | DAY OFF | 2022-09-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Fri | Jobe | 2022-09-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sat | Dysart | 2022-09-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Tue
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Fri
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sat
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Tue
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Fri
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sat
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Tue
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Fri
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sat
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Tue