Spreadsheet: 727429d1617893349-using-a-formula-to-create-a-daily-summary-of-a-monthly-rota-rota-example-with-formula
Sheet: Sheet1

 |  | Person 1 | Person 2 | Person 3 | Person 4 | Person 5 | Person 6 | Person 7 | Person 8 | Person 9 | Person 10 | Person 11 | Person 12 | Person 13 | Person 14 | Person 15 | Person 16 | Person 17 | Person 18 | Person 19 | Person 20 | Person 21 | Person 22 | Person 23 | Person 24 | Person 25 | Person 26 | Person 27 | Person 28 | Person 29 | Person 30 | Person 31 | Person 32
 |  | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8
2021-05-01 00:00:00 | Saturday | OFF | OFF | OFF | OFF | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | OFF | OFF | OFF | OFF | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00
2021-05-02 00:00:00 | Sunday | OFF | OFF | OFF | OFF | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | OFF | OFF | OFF | OFF | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00
2021-05-03 00:00:00 | Monday | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | OFF | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | 10:30-21:30 | OFF | 12:00 - 23:00 | 12:00 - 23:00 | AL | 12:00 - 23:00 | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF
2021-05-04 00:00:00 | Tuesday | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | OFF | OFF | OFF | OFF | OFF | OFF | OFF | 10:30-21:30 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 11:00 - 22:00 | 11:00 - 22:00 | OFF | 10:30-21:30 | OFF | OFF | OFF | OFF | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 21:00 - 08:00 | 21:00 - 08:00 | AL | 21:00 - 08:00
2021-05-05 00:00:00 | Wednesday | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | OFF | OFF | OFF | OFF | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 21:00 - 08:00 | 21:00 - 08:00 | AL | 21:00 - 08:00
2021-05-06 00:00:00 | Thursday | OFF | OFF | OFF | OFF | 10:30-21:30 | AL | AL | 10:30-21:30 | OFF | OFF | OFF | OFF | OFF | OFF | 21:00 - 08:00 | 21:00 - 08:00 | 10:30-21:30 | 10:30-21:30 | 11:00 - 22:00 | OFF | 07:30 - 18:30 | 07:30 - 18:30 | AL | 07:30 - 18:30 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 21:00 - 08:00 | 21:00 - 08:00 | AL | 21:00 - 08:00
2021-05-07 00:00:00 | Friday | RR | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 12:00 - 23:00 | AL | AL | 12:00 - 23:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | OFF | OFF | OFF | 11:00 - 22:00 | 07:30 - 18:30 | 07:30 - 18:30 | AL | 07:30 - 18:30 | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF
2021-05-08 00:00:00 | Saturday | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | OFF | OFF | OFF | OFF | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | OFF | OFF | OFF | OFF
2021-05-09 00:00:00 | Sunday | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | OFF | OFF | OFF | OFF | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | OFF | OFF | OFF | OFF
2021-05-10 00:00:00 | Monday | OFF | OFF | OFF | OFF | 07:30 - 18:30 | AL | AL | 07:30 - 18:30 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 10:30-21:30 | 10:30-21:30 | AL | OFF | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | 11:00 - 22:00 | OFF | AL | OFF | AL | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | OFF | OFF | OFF | OFF
2021-05-11 00:00:00 | Tuesday | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 07:30 - 18:30 | AL | AL | 07:30 - 18:30 | OFF | OFF | OFF | OFF | OFF | OFF | OFF | 10:30-21:30 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | SL | OFF | 11:00 - 22:00 | OFF | 10:30-21:30 | OFF | OFF | OFF | OFF | 12:00 - 23:00 | 12:00 - 23:00 | AL | 12:00 - 23:00
2021-05-12 00:00:00 | Wednesday | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 07:30 - 18:30 | AL | AL | 07:30 - 18:30 | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | AL | 10:30-21:30 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 10:30-21:30 | 10:30-21:30 | AL | 10:30-21:30 | OFF | OFF | OFF | OFF | 12:00 - 23:00 | 12:00 - 23:00 | AL | 12:00 - 23:00
2021-05-13 00:00:00 | Thursday | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | OFF | OFF | OFF | OFF | OFF | OFF | 21:00 - 08:00 | 21:00 - 08:00 | 10:30-21:30 | 10:30-21:30 | AL | OFF | AL | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 12:00 - 23:00 | 12:00 - 23:00 | AL | 12:00 - 23:00
2021-05-14 00:00:00 | Friday | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | AL | 10:30-21:30 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | OFF | OFF | OFF | 11:00 - 22:00 | AL | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | OFF | OFF | OFF | OFF
2021-05-15 00:00:00 | Saturday | OFF | OFF | OFF | OFF | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | OFF | OFF | OFF | OFF | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30
2021-05-16 00:00:00 | Sunday | OFF | OFF | OFF | OFF | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | OFF | OFF | OFF | OFF | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30
2021-05-17 00:00:00 | Monday | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 10:30-21:30 | 10:30-21:30 | AL | OFF | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | 11:00 - 22:00 | OFF | 10:30-21:30 | OFF | 12:00 - 23:00 | 12:00 - 23:00 | AL | 12:00 - 23:00
2021-05-18 00:00:00 | Tuesday | AL | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | OFF | OFF | OFF | OFF | OFF | OFF | OFF | 10:30-21:30 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | 11:00 - 22:00 | OFF | 10:30-21:30 | OFF | OFF | OFF | OFF
2021-05-19 00:00:00 | Wednesday | AL | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | AL | 10:30-21:30 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | OFF | OFF | OFF | OFF
2021-05-20 00:00:00 | Thursday | AL | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | AL | 10:30-21:30 | OFF | OFF | OFF | OFF | OFF | OFF | 21:00 - 08:00 | 21:00 - 08:00 | 10:30-21:30 | 10:30-21:30 | 11:00 - 22:00 | OFF | 07:30 - 18:30 | 07:30 - 18:30 | AL | 07:30 - 18:30
2021-05-21 00:00:00 | Friday | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 12:00 - 23:00 | 12:00 - 23:00 | AL | AL | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | OFF | OFF | OFF | 11:00 - 22:00 | 07:30 - 18:30 | 07:30 - 18:30 | AL | 07:30 - 18:30
2021-05-22 00:00:00 | Saturday | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | OFF | OFF | OFF | OFF | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | OFF | OFF | OFF | OFF | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | OFF | OFF | OFF | OFF
2021-05-23 00:00:00 | Sunday | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | OFF | OFF | OFF | OFF | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | OFF | OFF | OFF | OFF | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | OFF | OFF | OFF | OFF
2021-05-24 00:00:00 | Monday | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | AL | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | OFF | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | 11:00 - 22:00 | OFF | 10:30-21:30 | OFF
2021-05-25 00:00:00 | Tuesday | OFF | OFF | OFF | OFF | 12:00 - 23:00 | 12:00 - 23:00 | AL | 12:00 - 23:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | RR | OFF | OFF | OFF | OFF | OFF | OFF | OFF | 10:30-21:30 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | 11:00 - 22:00 | OFF | 10:30-21:30
2021-05-26 00:00:00 | Wednesday | OFF | OFF | OFF | OFF | 12:00 - 23:00 | 12:00 - 23:00 | AL | 12:00 - 23:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | RR | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30
2021-05-27 00:00:00 | Thursday | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 12:00 - 23:00 | 12:00 - 23:00 | AL | 12:00 - 23:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | AL | 10:30-21:30 | OFF | OFF | OFF | OFF | OFF | OFF | 21:00 - 08:00 | 21:00 - 08:00 | 10:30-21:30 | 10:30-21:30 | 11:00 - 22:00 | OFF
2021-05-28 00:00:00 | Friday | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | OFF | OFF | OFF | 11:00 - 22:00
2021-05-29 00:00:00 | Saturday | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | OFF | OFF | OFF | OFF | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | OFF | OFF | OFF | OFF | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30
2021-05-30 00:00:00 | Sunday | OFF | OFF | OFF | OFF | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | OFF | OFF | OFF | OFF | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | 12:00 - 23:00 | OFF | OFF | OFF | OFF | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF | OFF | OFF | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30
2021-05-31 00:00:00 | Monday | 11:00 - 22:00 | OFF | 10:30-21:30 | OFF | 12:00 - 23:00 | 12:00 - 23:00 | AL | 12:00 - 23:00 | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 07:30 - 18:30 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 21:00 - 08:00 | 10:30-21:30 | 10:30-21:30 | 10:30-21:30 | OFF | 21:00 - 08:00 | 21:00 - 08:00 | OFF | OFF
 | 2021-05-01 00:00:00 | 07:30 - 18:30 | 10:30-21:30 | 11:00 - 22:00 | 12:00 - 23:00 | 21:00 - 08:00