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

 |  |  |  |  |  | January
 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-01-02 00:00:00 | 2023-01-03 00:00:00 | 2023-01-04 00:00:00 | 2023-01-05 00:00:00 | 2023-01-06 00:00:00 | 2023-01-07 00:00:00 | 2023-01-08 00:00:00 | 2023-01-09 00:00:00 | 2023-01-10 00:00:00 | 2023-01-11 00:00:00 | 2023-01-12 00:00:00 | 2023-01-13 00:00:00 | 2023-01-14 00:00:00 | 2023-01-15 00:00:00 | 2023-01-16 00:00:00 | 2023-01-17 00:00:00 | 2023-01-18 00:00:00 | 2023-01-19 00:00:00 | 2023-01-20 00:00:00 | 2023-01-21 00:00:00 | 2023-01-22 00:00:00 | 2023-01-23 00:00:00 | 2023-01-24 00:00:00 | 2023-01-25 00:00:00 | 2023-01-26 00:00:00 | 2023-01-27 00:00:00 | 2023-01-28 00:00:00 | 2023-01-29 00:00:00 | 2023-01-30 00:00:00 | 2023-01-31 00:00:00
 |  |  |  |  |  | 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 | Tuesday
 | Carryover | Allocation | Remaining | Sick C/O | Sickness
Team Leader
 |  |  |  | 1 |  |  | PH |  |  | s | s | fn |  | 06:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Carryover | Carryover2 | Carryover3 | Carryover4 | Annual Leave
 |  |  |  |  |  |  |  | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0:15:00 | 12:30:00 | 1 day, 0:45:00 | 1 day, 13:00:00 | 9 days, 15:00:00
 |  |  |  | 1 |  | 9:00:00 | PH | PH | 06:30:00 |  |  |  |  |  |  | 01:00:00 |  | 01:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02: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
 |  |  |  | 0 |  |  |  | DT | 09:00:00 | 09:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:00:00 | 13:15:00 | 1 day, 1:30:00 | 1 day, 13:45:00 | 8 days, 18:00:00
 |  |  |  |  |  |  | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1:15:00 | 13:30:00 | 1 day, 1:45:00 | 1 day, 14:00:00 | 8 days, 11:00:00
 |  |  |  | 0 |  |  |  | PH | 09:00:00 | 09:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:00:00 |  |  |  |  |  |  |  |  | 1:30:00 | 13:45:00 | 1 day, 2:00:00 | 1 day, 14:15:00 | 8 days, 4:00:00
 |  |  |  |  |  |  | 07: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
 |  |  |  |  |  |  |  |  | 08:30:00 |  |  |  |  |  | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:15:00 |  |  |  |  |  |  |  |  |  |  |  | 2:45:00 | 15:00:00 | 1 day, 3:15:00 | 1 day, 15:30:00
 |  |  |  |  |  |  | 07:20:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3:00:00 | 15:15:00 | 1 day, 3:30:00 | 1 day, 15:45:00 | 7 days, 2:00:00
 |  |  |  |  |  |  | PH |  |  |  |  | 09:00:00 |  |  |  | 06:00:00 |  |  |  |  |  | 01:00:00 | 02:00:00 |  |  |  |  |  |  | 09:30:00 | 09:30:00 | 09:30:00 |  |  | 03: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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00 |  | 09:00:00 | 09:00:00 | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4:00:00 | 16:15:00 | 1 day, 4:30:00 | 1 day, 16:45:00 | 8 days, 8:00:00
 |  |  |  |  |  |  | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4:15:00 | 16:30:00 | 1 day, 4:45:00 | 1 day, 17:00:00 | 8 days, 15:00:00
 |  |  |  |  |  | 9:00:00 | PH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4:30:00 | 16:45:00 | 1 day, 5:00:00 | 1 day, 17:15:00 | 8 days, 23: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
 |  |  |  |  |  | 6:15:00 |  | PH | 04:30:00 | 04:30:00 | 04:30:00 |  |  |  |  |  |  | 05:00:00 |  |  | 04:30:00 |  |  |  |  | 06:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5:30:00 | 17:45:00 | 1 day, 6:00:00 | 1 day, 18:30:00 | 10 days, 4:00:00
 |  |  |  |  |  |  | 04:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5:45:00 | 18:00:00 | 1 day, 6:15:00 | 1 day, 18:45:00 | 5 days, 12:00:00
 |  |  |  |  |  |  | PH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:00:00 |  |  | 04:30:00 | 05:00:00 |  |  |  |  |  | 6:00:00 | 18:15:00 | 1 day, 6:30:00 | 1 day, 19:00:00 | 4 days, 12:00:00
 |  |  |  |  |  |  |  | 04:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6:15:00 | 18:30:00 | 1 day, 6:45:00 | 1 day, 19:30:00 | 4 days, 0:00:00
 |  |  |  |  |  |  | PH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:15:00 | 06:15:00 |  |  |  |  |  |  |  | 6:30:00 | 18:45:00 | 1 day, 7:00:00 | 1 day, 19:45:00 | 3 days, 16:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6:45:00 | 19:00:00 | 1 day, 7:15:00 | 1 day, 20:00:00 | 7 days, 1:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 19:15:00 | 1 day, 7:30:00 |  | 7 days, 2:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:15:00 | 19:30:00 | 1 day, 7:45:00 |  | 7 days, 3:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:30:00 | 19:45:00 | 1 day, 8:00:00 |  | 7 days, 4:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:45:00 | 20:00:00 | 1 day, 8:15:00 |  | 7 days, 5:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:00:00 | 20:15:00 | 1 day, 8:30:00 |  | 7 days, 6:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:15:00 | 20:30:00 | 1 day, 8:45:00 |  | 7 days, 7:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:30:00 | 20:45:00 | 1 day, 9:00:00 |  | 7 days, 8:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:45:00 | 21:00:00 | 1 day, 9:15:00 |  | 7 days, 9:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9:15:00 | 21:30:00 | 1 day, 9:45:00 |  | 7 days, 10:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9:30:00 | 21:45:00 | 1 day, 10:00:00 |  | 7 days, 11:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9:45:00 | 22:00:00 | 1 day, 10:15:00 |  | 7 days, 12:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 days, 13:00:00
Venue Assistant |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 days, 11:30:00
 |  |  |  |  |  | 7:00:00 | PH |  |  |  |  |  |  |  |  |  |  | 08:30:00 |  |  | 08:30:00 | 08:30:00 | 08:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:15:00 | 22:30:00 | 1 day, 10:45:00 |  | 9 days, 0:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00 | 22:45:00 | 1 day, 11:00:00
 |  |  |  |  |  |  | PH |  | 08:30:00 |  |  |  |  |  | 06:00:00 | 06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:45:00 | 23:00:00 | 1 day, 11:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00 | 23:15:00 | 1 day, 11:30:00
 |  |  |  |  |  |  | PH | PH | 08:00:00 | 09:00:00 | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:00:00 |  |  | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  | 11:15:00 | 23:30:00 | 1 day, 11:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00 | 23:45:00 | 1 day, 12:00:00
 |  |  |  |  |  |  | PH | PH |  | 06:00:00 | 01:00:00 | 09:30:00 | 09:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 |  | 07:30:00 | 07:30:00 | 07:30:00 |  |  |  | 07: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
 |  |  |  |  |  | 9:30:00 | PH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:15:00 | 1 day, 0:30:00 | 1 day, 12:45:00
 |  |  |  |  |  |  |  | 07:20:00
 |  |  |  |  |  | 9:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:00:00
 |  |  |  |  |  |  | 07:20:00
 |  |  |  |  |  | 7:30:00 | PH |  |  |  |  |  |  |  |  |  | 07:30:00 |  |  |  |  |  |  |  |  |  | 09:30:00 | 06:00:00
 |  |  |  |  |  |  | PH |  |  |  |  |  |  |  |  |  |  | 06:30:00 | 09:30:00
 |  |  |  |  |  |  | PH
 |  |  |  |  |  |  | PH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00
 |  |  |  |  |  | 9:30:00 |  |  |  |  |  |  |  |  | 06:00:00
 |  |  |  |  |  |  | 04:00:00
 |  |  |  |  |  |  | PH | PH |  |  |  | 07:00:00
 | 00:00:00
 |  |  |  |  |  |  | 04:00:00 | 04:00:00