Spreadsheet: 838803d1691418850-edit-a-formula-by-date-to-return-0-toddp2-test-file
Sheet: Jul23

 |  |  |  |  |  | July
 |  |  |  |  |  | 2023-07-01 00:00:00 | 2023-07-02 00:00:00 | 2023-07-03 00:00:00 | 2023-07-04 00:00:00 | 2023-07-05 00:00:00 | 2023-07-06 00:00:00 | 2023-07-07 00:00:00 | 2023-07-08 00:00:00 | 2023-07-09 00:00:00 | 2023-07-10 00:00:00 | 2023-07-11 00:00:00 | 2023-07-12 00:00:00 | 2023-07-13 00:00:00 | 2023-07-14 00:00:00 | 2023-07-15 00:00:00 | 2023-07-16 00:00:00 | 2023-07-17 00:00:00 | 2023-07-18 00:00:00 | 2023-07-19 00:00:00 | 2023-07-20 00:00:00 | 2023-07-21 00:00:00 | 2023-07-22 00:00:00 | 2023-07-23 00:00:00 | 2023-07-24 00:00:00 | 2023-07-25 00:00:00 | 2023-07-26 00:00:00 | 2023-07-27 00:00:00 | 2023-07-28 00:00:00 | 2023-07-29 00:00:00 | 2023-07-30 00:00:00 | 2023-07-31 00:00:00
 |  |  |  |  |  | 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 | Thursday | Friday | Saturday | Sunday | Monday
 | Allocation | Remaining | Sickness
Team Leader
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:30:00 | 06:30: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
 |  |  |  |  |  |  |  |  |  |  | 09:30:00 |  |  |  |  |  |  |  |  | 09:00:00 | 09:00:00 | 09:00:00 | 09:30:00 |  |  |  | 06:00:00 | 06:00:00 |  | 09:00:00 |  |  | 08:00:00 |  |  |  |  |  |  |  |  | 0:30:00 | 12:45:00 | 1 day, 1:00:00 | 1 day, 13:15:00 | 9 days, 8:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0:45:00 | 13:00:00 | 1 day, 1:15:00 | 1 day, 13:30:00 | 9 days, 1:00:00
 |  |  |  |  |  |  |  | 06:30:00 | 02:00:00 |  |  |  |  |  |  |  | 06:00:00 | 06;00 |  |  |  |  |  |  |  | 08:00:00 |  |  | 09:30:00 |  | 09:30:00 | 09:30:00 | 09:30:00 |  |  |  |  |  |  |  |  | 1:00:00 | 13:15:00 | 1 day, 1:30:00 | 1 day, 13:45:00 | 8 days, 18:00:00
 |  |  |  |  |  |  |  |  |  | 02:30:00 |  |  |  |  |  | 02:00:00 |  |  |  |  |  |  |  |  |  | 02:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:15:00 | 13:30:00 | 1 day, 1:45:00 | 1 day, 14:00:00 | 8 days, 11:00:00
 |  |  |  |  |  |  |  |  | 09:00:00 | 09:00:00 | 09:00:00 | 08:00:00 |  |  | 08:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:30:00 | 13:45:00 | 1 day, 2:00:00 | 1 day, 14:15:00 | 8 days, 4:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:45:00 | 14:00:00 | 1 day, 2:15:00 | 1 day, 14:30:00 | 7 days, 21:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:30:00 | 08:30:00 | 08:30:00 |  |  | 07:00:00 | 07:00:00 |  |  |  |  |  |  | 2:45:00 | 15:00:00 | 1 day, 3:15:00 | 1 day, 15:30:00
 |  |  |  |  |  |  |  |  | 02:00:00 |  |  |  |  |  |  | 02:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3:00:00 | 15:15:00 | 1 day, 3:30:00 | 1 day, 15:45:00 | 7 days, 2:00:00
 |  |  |  |  |  | 7:00:00 | 7:00:00 | 08:30:00 |  |  | 08:30:00 | 08:30:00 | 06:00:00 | 06:00:00 |  |  |  |  |  |  |  |  |  | 08:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3:15:00 | 15:30:00 | 1 day, 3:45:00 | 1 day, 16:00:00 | 7 days, 10:00: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
 |  |  |  |  |  |  |  | 07:00:00 | 07:00:00 | 07:00:00 | 07: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 | 08:00:00 | 08:00:00 |  |  | 08:00:00 | 07:00:00 |  | 07:00:00 | 07:00:00 | 06:00:00 | 06:00:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4:30:00 | 16:45:00 | 1 day, 5:00:00 | 1 day, 17:15:00 | 8 days, 23: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 |  |  |  |  |  |  | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 |  |  | 08: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 |  |  |  |  |  |  |  |  |  |  |  | 6:00:00 | 18:15:00 | 1 day, 6:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6:15:00 | 18:30:00 | 1 day, 6:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00 | 09:00:00 |  | 08:00:00 | 07:00:00 | 08:00:00 | 08:00:00 |  |  | 08:00:00 | 07:00:00 |  | 02:00:00 | 02:00:00 |  |  | 02:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 6:30:00 | 18:45:00 | 1 day, 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:15:00 | 22:30:00 | 1 day, 10:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00 | 22:45:00 | 1 day, 11:00:00
 |  |  |  |  |  |  | 6:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 | 08:00:00 | 08:00:00 | 09:00:00 | 08:00:00 |  |  | 07:50:00 | 07:50:00 | 07:50:00 | 07:50:00 | 07:50:00 |  |  |  |  |  |  |  |  | 10:45:00 | 23:00:00 | 1 day, 11:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00 | 23:15:00 | 1 day, 11:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 | 07:30:00 | 07:30:00 |  |  |  |  |  |  |  | 09:30:00 | 09:30:00 |  |  |  |  |  |  | 11:15:00 | 23:30:00 | 1 day, 11:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00 | 23:45:00 | 1 day, 12:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 | 07:30:00 |  | 07:00:00 | 07:30:00 | 06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:15:00 | 1 day, 0:30:00 | 1 day, 12:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 |  |  | 07:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00
 |  |  |  |  |  |  |  |  |  | 08:00:00 |  | 08:00:00 |  |  | 07:30:00 | 07:30:00 |  |  |  |  |  | 07:00:00 | 07:00:00 | 07:00:00 |  |  |  |  |  |  |  |  | 08:00:00 |  |  | 07:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 |  |  | 09:30:00 | 09:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s | s | s |  |  |  | s |  |  | FN | FN | FN |  | FN | FN | FN |  |  |  | FN