Spreadsheet: 838824d1691427019-edit-a-formula-by-date-to-return-0-toddp2-test-file
Sheet: May23

 |  |  |  |  |  | May
 |  |  |  |  |  | 2023-05-01 00:00:00 | 2023-05-02 00:00:00 | 2023-05-03 00:00:00 | 2023-05-04 00:00:00 | 2023-05-05 00:00:00 | 2023-05-06 00:00:00 | 2023-05-07 00:00:00 | 2023-05-08 00:00:00 | 2023-05-09 00:00:00 | 2023-05-10 00:00:00 | 2023-05-11 00:00:00 | 2023-05-12 00:00:00 | 2023-05-13 00:00:00 | 2023-05-14 00:00:00 | 2023-05-15 00:00:00 | 2023-05-16 00:00:00 | 2023-05-17 00:00:00 | 2023-05-18 00:00:00 | 2023-05-19 00:00:00 | 2023-05-20 00:00:00 | 2023-05-21 00:00:00 | 2023-05-22 00:00:00 | 2023-05-23 00:00:00 | 2023-05-24 00:00:00 | 2023-05-25 00:00:00 | 2023-05-26 00:00:00 | 2023-05-27 00:00:00 | 2023-05-28 00:00:00 | 2023-05-29 00:00:00 | 2023-05-30 00:00:00 | 2023-05-31 00:00:00
 |  |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday
 | Allocation | Remaining | Sickness
Team Leader
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s | s |  |  |  |  | 06:00:00 |  |  |  |  |  | Carryover | Carryover2 | Carryover3 | Carryover4 | Annual Leave
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0:15:00 | 12:30:00 | 1 day, 0:45:00 | 1 day, 13:00:00 | 9 days, 15:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:00:00 |  |  |  |  | 09:00:00 |  |  |  | 06:00:00 |  |  |  |  |  |  |  |  |  |  |  | 0:30:00 | 12:45:00 | 1 day, 1:00:00 | 1 day, 13:15:00 | 9 days, 8:00:00
 |  |  |  |  |  | 7:00:00 |  |  |  |  |  |  |  |  |  |  | 06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 |  |  |  |  |  |  |  | 0:45:00 | 13:00:00 | 1 day, 1:15:00 | 1 day, 13:30:00 | 9 days, 1:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00 | 06:00:00 | 06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:00:00 | 13:15:00 | 1 day, 1:30:00 | 1 day, 13:45:00 | 8 days, 18:00:00
 |  |  |  |  |  |  | 06:00:00 | 05:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:15:00 | 13:30:00 | 1 day, 1:45:00 | 1 day, 14:00:00 | 8 days, 11:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00 |  |  |  |  |  |  | 1:30:00 | 13:45:00 | 1 day, 2:00:00 | 1 day, 14:15:00 | 8 days, 4:00:00
 |  |  |  |  |  |  | 06:00:00 | 05:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:45:00 | 14:00:00 | 1 day, 2:15:00 | 1 day, 14:30:00 | 7 days, 21:00:00
Assistant Team Leader |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2:00:00 | 14:15:00 | 1 day, 2:30:00 | 1 day, 14:45:00 | 7 days, 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2:15:00 | 14:30:00 | 1 day, 2:45:00 | 1 day, 15:00:00 | 7 days, 7:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2:30:00 | 14:45:00 | 1 day, 3:00:00 | 1 day, 15:15:00 | 7 days, 0:00:00
 |  |  |  |  |  |  | 6:00:00 | 06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:00:00 |  |  |  |  |  |  | 2:45:00 | 15:00:00 | 1 day, 3:15:00 | 1 day, 15:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 07:24:00 |  |  |  |  |  |  |  |  |  | 01:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3:00:00 | 15:15:00 | 1 day, 3:30:00 | 1 day, 15:45:00 | 7 days, 2:00:00
 |  |  |  |  |  |  |  |  |  |  | 06:00:00 | 06:00:00 |  |  |  |  | 06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3:15:00 | 15:30:00 | 1 day, 3:45:00 | 1 day, 16:00:00 | 7 days, 10:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 07:24:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:24:00 |  |  |  |  |  |  |  | 3:30:00 | 15:45:00 | 1 day, 4:00:00 | 1 day, 16:15:00 | 7 days, 17:00:00
Front of House |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3:45:00 | 16:00:00 | 1 day, 4:15:00 | 1 day, 16:30:00 | 8 days, 0:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 |  |  |  |  |  | 4:00:00 | 16:15:00 | 1 day, 4:30:00 | 1 day, 16:45:00 | 8 days, 8:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4:15:00 | 16:30:00 | 1 day, 4:45:00 | 1 day, 17:00:00 | 8 days, 15:00:00
 |  |  |  |  |  |  |  |  | 07:00:00 | 07:00:00 |  |  |  |  | 03:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4:30:00 | 16:45:00 | 1 day, 5:00:00 | 1 day, 17:15:00 | 8 days, 23:00:00
 |  |  |  |  |  | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 |  |  |  |  |  |  |  | 4:45:00 | 17:00:00 | 1 day, 5:15:00 | 1 day, 17:30:00 | 9 days, 6:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5:00:00 | 17:15:00 | 1 day, 5:30:00 | 1 day, 17:45:00 | 9 days, 13:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5:15:00 | 17:30:00 | 1 day, 5:45:00 | 1 day, 18:00:00 | 9 days, 21:00:00
 |  |  |  |  |  |  |  |  |  | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5:30:00 | 17:45:00 | 1 day, 6:00:00 |  | 10 days, 4:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5:45:00 | 18:00:00 | 1 day, 6:15:00
 |  |  |  |  |  |  |  |  | 07:00:00 | 07:00:00 |  |  |  | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00 |  |  | 07:00:00 | 07:00:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6:00:00 | 18:15:00 | 1 day, 6:30:00
 |  |  |  |  |  | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 |  |  |  |  |  |  |  | 6:15:00 | 18:30:00 | 1 day, 6:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 07:00:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  | 6:30:00 | 18:45:00 | 1 day, 7:00:00
 |  |  |  |  |  | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6:45:00 | 19:00:00 | 1 day, 7:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 19:15:00 | 1 day, 7:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:15:00 | 19:30:00 | 1 day, 7:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:30:00 | 19:45:00 | 1 day, 8:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:45:00 | 20:00:00 | 1 day, 8:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00 | 20:15:00 | 1 day, 8:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:15:00 | 20:30:00 | 1 day, 8:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:30:00 | 20:45:00 | 1 day, 9:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:45:00 | 21:00:00 | 1 day, 9:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9:15:00 | 21:30:00 | 1 day, 9:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9:30:00 | 21:45:00 | 1 day, 10:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9:45:00 | 22:00:00 | 1 day, 10:15:00
Venue Assistant
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 |  |  |  |  |  |  |  | 05:30:00 |  |  | 07:30:00 |  |  |  |  | 07:00:00 |  |  |  |  |  | 10:15:00 | 22:30:00 | 1 day, 10:45:00
 |  |  |  |  |  | 7:24:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:24:00 |  |  |  |  |  |  |  | 10:30:00 | 22:45:00 | 1 day, 11:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:45:00 | 23:00:00 | 1 day, 11:15:00
 |  |  |  |  |  | 7:24:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00 | 23:15:00 | 1 day, 11:30:00
 |  |  |  |  |  |  |  | 06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:15:00 | 23:30:00 | 1 day, 11:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:24:00 |  |  |  |  |  |  |  | 11:30:00 | 23:45:00 | 1 day, 12:00:00
 |  |  |  |  |  | fn | fn | fn | fn | fn |  |  | fn | fn |  | fn | fn | fn | fn | fn |  | fn | fn | fn |  |  | fn | fn | fn | fn | fn |  |  | fn | fn | fn |  |  |  |  |  | 11:45:00 | 1 day, 0:00:00 | 1 day, 12:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 | 1 day, 0:15:00 | 1 day, 12:30:00
 |  |  |  |  |  |  |  |  |  |  | 09:30:00 | 09:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 |  |  |  |  |  |  |  |  |  |  | 12:15:00 | 1 day, 0:30:00 | 1 day, 12:45:00
 |  |  |  |  |  |  |  |  |  |  | 09:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 | 07:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 07:24:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:30:00
 |  |  |  |  |  | 7:24:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:00:00 |  | 06:00:00 | 06:00:00 | 06:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 |  |  |  |  |  |  | 07:00:00 |  |  | 09:30:00 |  |  |  |  |  |  |  |  |  |  | 07:30:00
 |  |  |  |  |  |  |  |  | 07:30:00 | 07:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 04:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00
 |  |  |  |  |  | 4:00:00 |  |  |  |  |  |  | 04:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:00:00
 |  |  |  |  |  | 4:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:00:00