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

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