Spreadsheet: 867948d1714676265-percentage-in-28-day-cycles-team-1-attendance-sheet-2024-updated-with-worked-example-clarified
Sheet: 2024

 |  | Cols C to D looks at every event from the start date to TODAY |  | Cols E to G looks a specified 28 day period 30th Jan 26th Feb is manually calculated
 | Name | WAH | ATT | 28 day WAH | 28 Att | 28 day % | % WAH/ATT |  | Team 1 | [NAME] | WAH | DAY | RD | Training | Meeting | AL | 0.5 AL | PHL | 0.5 PHL | Toil | 0.5 Toil | 0.5 AL 0.5 Toil | 0.5 Al 0.5 PHL | 0.5 PHL 0.5 Toil | 0.5 AL WAH | 0.5 PHL WAH | 0.5 Toil WAH | USL | CSL | 0.5 CSL | 0.5 USL | 0.5 CSL WAH | 0.5 USL WAH | PRTL L | SWY | UPL | [NAME] | PRTS L | [NAME] | Other | Comp
 |  |  |  | 4 | 11 |  |  |  | Darragh
 |  |  |  | 5 | 13 |  |  |  | Chloe
 |  |  |  | 4 | 10 |  |  |  | Nicole
 |  |  |  | 3 | 11 |  |  |  | [NAME]
 |  |  |  | 3 | 7 |  |  |  | [NAME]
 |  |  |  | 3 | 9 |  |  |  | [NAME]
 |  |  |  | 3 | 9 |  |  |  | Kathy
 |  |  |  | 3 | 9 |  |  |  | Emma
 |  |  |  | 3 | 10 |  |  |  | Michelle
 |  |  |  | 5 | 15 |  |  |  | Dennis
 |  |  |  | 5 | 14 |  |  |  | [NAME]
 |  |  |  | 4 | 15 |  |  |  | [NAME]
 |  |  |  | 0 | 13 |  |  |  | Roise
 |  |  |  |  |  |  |  |  | Benoy
 |  |  |  |  |  |  |  |  | Sinead
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEAM CROSSOVER
 |  |  |  |  |  |  |  |  | Date | Day | Shift | Darragh | Chloe | Nicole | [NAME] | [NAME] | [NAME] | Kathy | Emma | Michelle | Dennis | [NAME] | [NAME] | Roise | Benoy | Sinead | Check Set Up | Comments | Column4 | Column3 | Column32 | Column1 | Column2
 |  |  |  |  |  |  |  |  | 2024-01-30 00:00:00 | Tuesday | Rest | RD | RD | RD | Training | RD | Training | Training | Training | RD | Training | RD | Training | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-01-31 00:00:00 | Wednesday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-01 00:00:00 | Thursday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-02 00:00:00 | Friday | Day | [NAME] | [NAME] | PHL | [NAME] | AL | PHL | AL | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-03 00:00:00 | Saturday | Day | [NAME] | [NAME] | PHL | [NAME] | RD | RD | RD | RD | WAH | WAH | [NAME] | WAH | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-04 00:00:00 | Sunday | Day | WAH | PHL | PHL | WAH | RD | RD | RD | RD | [NAME] | [NAME] | WAH | [NAME] | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-05 00:00:00 | Monday | Day | [NAME] | [NAME] | PHL | [NAME] | [NAME] | PHL | PHL | WAH | AL | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-06 00:00:00 | Tuesday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-07 00:00:00 | Wednesday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-08 00:00:00 | Thursday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-09 00:00:00 | Friday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-10 00:00:00 | Saturday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-11 00:00:00 | Sunday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-12 00:00:00 | Monday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-13 00:00:00 | Tuesday | Night | WAH | [NAME] | [NAME] | PHL | [NAME] | [NAME] | WAH | WAH | [NAME] | WAH | WAH | WAH | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-14 00:00:00 | Wednesday | Night | [NAME] | WAH | WAH | PHL | WAH | WAH | [NAME] | [NAME] | WAH | [NAME] | WAH | [NAME] | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-15 00:00:00 | Thursday | Night | [NAME] | WAH | [NAME] | PHL | [NAME] | WAH | WAH | [NAME] | WAH | WAH | [NAME] | WAH | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-16 00:00:00 | Friday | Night | WAH | WAH | WAH | PHL | PHL | [NAME] | [NAME] | PHL | [NAME] | [NAME] | WAH | [NAME] | AL |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-17 00:00:00 | Saturday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-18 00:00:00 | Sunday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-19 00:00:00 | Monday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-20 00:00:00 | Tuesday | Day | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | WAH | [NAME] | AL | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-21 00:00:00 | Wednesday | Day | [NAME] | [NAME] | [NAME] | [NAME] | PHL | WAH | [NAME] | [NAME] | 0.5 AL | [NAME] | [NAME] | [NAME] | [NAME] | PHL | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-22 00:00:00 | Thursday | Day | WAH | [NAME] | [NAME] | [NAME] | WAH | [NAME] | [NAME] | PHL | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-23 00:00:00 | Friday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-24 00:00:00 | Saturday | Night | PHL | WAH | WAH | WAH | RD | RD | RD | RD | [NAME] | WAH | [NAME] | [NAME] | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-25 00:00:00 | Sunday | Night | PHL | WAH | WAH | [NAME] | RD | RD | RD | RD | [NAME] | [NAME] | WAH | WAH | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-26 00:00:00 | Monday | Night | PHL | [NAME] | [NAME] | WAH | WAH | [NAME] | [NAME] | WAH | 0.5 PHL | WAH | [NAME] | [NAME] | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-27 00:00:00 | Tuesday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-28 00:00:00 | Wednesday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-02-29 00:00:00 | Thursday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-01 00:00:00 | Friday | Day | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | PHL | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-02 00:00:00 | Saturday | Day | [NAME] | PHL | [NAME] | [NAME] | WAH | PHL | WAH | WAH | RD | RD | RD | RD | RD | WAH | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-03 00:00:00 | Sunday | Day | WAH | PHL | WAH | WAH | [NAME] | PHL | [NAME] | [NAME] | RD | RD | RD | RD | RD | WAH | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-04 00:00:00 | Monday | Day | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | PHL | [NAME] | [NAME] | PHL | WAH | WAH | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-05 00:00:00 | Tuesday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-06 00:00:00 | Wednesday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-07 00:00:00 | Thursday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-08 00:00:00 | Friday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-09 00:00:00 | Saturday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-10 00:00:00 | Sunday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-11 00:00:00 | Monday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-12 00:00:00 | Tuesday | Night | [NAME] | PHL | WAH | WAH | PHL | [NAME] | [NAME] | WAH | PHL | WAH | WAH | WAH | WAH |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-13 00:00:00 | Wednesday | Night | [NAME] | PHL | [NAME] | [NAME] | WAH | WAH | WAH | [NAME] | 0.5 PHL WAH | WAH | [NAME] | WAH | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-14 00:00:00 | Thursday | Night | WAH | PHL | WAH | WAH | [NAME] | [NAME] | [NAME] | WAH | 0.5 PHL WAH | [NAME] | WAH | [NAME] | WAH |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-15 00:00:00 | Friday | Night | WAH | PHL | PHL | [NAME] | [NAME] | WAH | WAH | [NAME] | [NAME] | WAH | WAH | WAH | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-16 00:00:00 | Saturday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-17 00:00:00 | Sunday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-18 00:00:00 | Monday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-19 00:00:00 | Tuesday | Day | [NAME] |  |  |  | PHL |  |  |  | PHL |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-20 00:00:00 | Wednesday | Day | AL |  |  |  | [NAME] |  |  |  | 0.5 PHL |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-21 00:00:00 | Thursday | Day | AL |  |  |  | [NAME] |  |  |  | 0.5 PHL |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-22 00:00:00 | Friday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-23 00:00:00 | Saturday | Night | WAH |  |  |  | [NAME] |  |  |  | RD | RD | RD | RD | RD |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-24 00:00:00 | Sunday | Night | [NAME] |  | PHL |  | WAH |  |  |  | RD | RD | RD | RD | RD |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-25 00:00:00 | Monday | Night | [NAME] |  | PHL |  | WAH |  |  |  | [NAME] D | [NAME] D | [NAME] D | [NAME] D | [NAME] D |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-26 00:00:00 | Tuesday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-27 00:00:00 | Wednesday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-28 00:00:00 | Thursday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-29 00:00:00 | Friday | Day |  |  |  |  |  |  |  |  | PHL |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-30 00:00:00 | Saturday | Day | RD | RD | RD | RD |  |  |  |  | PHL |  |  |  |  | WAH | [NAME]
 |  |  |  |  |  |  |  |  | 2024-03-31 00:00:00 | Sunday | Day | RD | RD | RD | RD |  |  |  |  | PHL |  |  |  |  | WAH | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-01 00:00:00 | Monday | Day |  |  |  |  | WAH |  |  |  | [NAME] |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-02 00:00:00 | Tuesday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-03 00:00:00 | Wednesday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-04 00:00:00 | Thursday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-05 00:00:00 | Friday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-06 00:00:00 | Saturday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-07 00:00:00 | Sunday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-08 00:00:00 | Monday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-09 00:00:00 | Tuesday | Night | [NAME] D | [NAME] D | [NAME] D | [NAME] D | [NAME] |  |  |  | WAH |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-10 00:00:00 | Wednesday | Night | [NAME] D | [NAME] D | [NAME] D | [NAME] D | WAH |  |  |  | [NAME] |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-11 00:00:00 | Thursday | Night | [NAME] D | [NAME] D | [NAME] D | [NAME] D | WAH |  |  |  | [NAME] |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-12 00:00:00 | Friday | Night | RD | RD | RD | RD | [NAME] |  |  |  | WAH |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-13 00:00:00 | Saturday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-14 00:00:00 | Sunday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-15 00:00:00 | Monday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-16 00:00:00 | Tuesday | Day |  |  |  |  |  |  |  |  | PHL |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-17 00:00:00 | Wednesday | Day |  |  |  |  | WAH |  |  |  | 0.5 PHL |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-18 00:00:00 | Thursday | Day |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-19 00:00:00 | Friday | Rest | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | RD | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-20 00:00:00 | Saturday | Night | RD | RD | RD | RD |  |  |  |  | 0.5 PHL |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-21 00:00:00 | Sunday | Night | RD | RD | RD | RD |  |  |  |  | [NAME] |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | 2024-04-22 00:00:00 | Monday | Night | [NAME] D | [NAME] D | [NAME] D | [NAME] D | WAH |  |  |  | 0.5 PHL |  |  |  |  |  | [NAME]