Spreadsheet: 769816d1645700401-custom-week-number-based-on-4-weekly-schedule-custom-week-number
Sheet: Sheet1

Run | Week | Day | Scheduled Start Date | Scheduled End Date | Recurring Interval |  | Date Range
RUN 1 | *If E2 between date range start and end then return Week Num | Monday | 24-01-2022 08:00 | 24-01-2022 08:45 | 1 Weeks |  | Start | End | Week Num
RUN 1 |  | Monday | 24-01-2022 08:45 | 24-01-2022 09:30 | 1 Weeks |  | 2022-01-24 00:00:00 | 2022-01-28 00:00:00 | 1
RUN 1 |  | Monday | 24-01-2022 09:30 | 24-01-2022 10:15 | 1 Weeks |  |  |  | 2
RUN 1 |  | Monday | 24-01-2022 10:15 | 24-01-2022 11:00 | 1 Weeks |  |  |  | 3
RUN 1 |  | Monday | 24-01-2022 11:00 | 24-01-2022 11:45 | 1 Weeks |  |  |  | 4
RUN 1 |  | Monday | 24-01-2022 11:45 | 24-01-2022 12:30 | 1 Weeks |  |  |  | 1
RUN 1 |  | Monday | 24-01-2022 12:30 | 24-01-2022 13:30 | 1 Weeks |  |  |  | 2
RUN 1 |  | Monday | 24-01-2022 13:30 | 24-01-2022 14:30 | 1 Weeks |  |  |  | 3
RUN 1 |  | Monday | 24-01-2022 14:30 | 24-01-2022 15:30 | 1 Weeks |  |  |  | 4
RUN 1 |  | Monday | 24-01-2022 15:30 | 24-01-2022 16:30 | 1 Weeks |  |  |  | 1
RUN 1 |  | Monday | 24-01-2022 16:30 | 24-01-2022 17:00 | 1 Weeks |  |  |  | 2
RUN 1 |  | Tuesday | 25-01-2022 08:00 | 25-01-2022 08:30 | 1 Weeks |  |  |  | 3
RUN 1 |  | Tuesday | 25-01-2022 08:30 | 25-01-2022 09:00 | 1 Weeks |  |  |  | 4
RUN 1 |  | Tuesday | 25-01-2022 09:00 | 25-01-2022 09:30 | 1 Weeks |  |  |  | 1
RUN 1 |  | Tuesday | 25-01-2022 09:30 | 25-01-2022 10:00 | 1 Weeks |  |  |  | 2
RUN 1 |  | Tuesday | 25-01-2022 10:00 | 25-01-2022 10:30 | 1 Weeks |  |  |  | 3
RUN 1 |  | Tuesday | 25-01-2022 10:30 | 25-01-2022 11:00 | 1 Weeks |  |  |  | 4
RUN 1 |  | Tuesday | 25-01-2022 11:00 | 25-01-2022 11:30 | 1 Weeks |  |  |  | 1
RUN 1 |  | Tuesday | 25-01-2022 11:30 | 25-01-2022 12:00 | 1 Weeks |  |  |  | 2
RUN 1 |  | Tuesday | 25-01-2022 12:00 | 25-01-2022 12:30 | 4 Weeks |  |  |  | 3
RUN 1 |  | Tuesday | 25-01-2022 12:30 | 25-01-2022 13:00 | 1 Weeks |  |  |  | 4
RUN 1 |  | Tuesday | 25-01-2022 13:00 | 25-01-2022 13:30 | 1 Weeks |  |  |  | 1
RUN 1 |  | Tuesday | 25-01-2022 13:30 | 25-01-2022 14:00 | 1 Weeks |  |  |  | 2
RUN 1 |  | Tuesday | 25-01-2022 14:00 | 25-01-2022 14:30 | 1 Weeks |  |  |  | 3
RUN 1 |  | Tuesday | 25-01-2022 14:30 | 25-01-2022 15:00 | 1 Weeks |  |  |  | 4
RUN 1 |  | Tuesday | 25-01-2022 15:00 | 25-01-2022 15:30 | 1 Weeks |  |  |  | 1
RUN 1 |  | Tuesday | 25-01-2022 15:30 | 25-01-2022 16:00 | 1 Weeks |  |  |  | 2
RUN 1 |  | Tuesday | 25-01-2022 16:00 | 25-01-2022 16:30 | 1 Weeks |  |  |  | 3
RUN 1 |  | Tuesday | 25-01-2022 16:30 | 25-01-2022 17:00 | 1 Weeks |  |  |  | 4
RUN 1 |  | Wednesday | 26-01-2022 08:00 | 26-01-2022 09:00 | 1 Weeks |  |  |  | 1
RUN 1 |  | Wednesday | 26-01-2022 09:00 | 26-01-2022 10:00 | 1 Weeks |  |  |  | 2
RUN 1 |  | Wednesday | 26-01-2022 10:00 | 26-01-2022 11:00 | 1 Weeks |  |  |  | 3
RUN 1 |  | Wednesday | 26-01-2022 11:00 | 26-01-2022 12:00 | 1 Weeks |  |  |  | 4
RUN 1 |  | Wednesday | 26-01-2022 12:00 | 26-01-2022 13:00 | 1 Weeks |  |  |  | 1
RUN 1 |  | Wednesday | 26-01-2022 13:00 | 26-01-2022 15:00 | 1 Weeks |  |  |  | 2
RUN 1 |  | Wednesday | 26-01-2022 15:00 | 26-01-2022 16:00 | 1 Weeks |  |  |  | 3
RUN 1 |  | Wednesday | 26-01-2022 16:00 | 26-01-2022 17:00 | 1 Weeks |  |  |  | 4
RUN 1 |  | Thursday | 27-01-2022 08:00 | 27-01-2022 08:45 | 1 Weeks |  |  |  | 1
RUN 1 |  | Thursday | 27-01-2022 08:45 | 27-01-2022 09:30 | 1 Weeks |  |  |  | 2
RUN 1 |  | Thursday | 27-01-2022 09:30 | 27-01-2022 10:15 | 1 Weeks |  |  |  | 3
RUN 1 |  | Thursday | 27-01-2022 09:40 | 27-01-2022 10:00 | 4 Weeks |  |  |  | 4
RUN 1 |  | Thursday | 27-01-2022 10:15 | 27-01-2022 11:00 | 1 Weeks |  |  |  | 1
RUN 1 |  | Thursday | 27-01-2022 11:00 | 27-01-2022 11:45 | 2 Weeks |  |  |  | 2
RUN 1 |  | Thursday | 27-01-2022 11:45 | 27-01-2022 12:30 | 4 Weeks |  |  |  | 3
RUN 1 |  | Thursday | 27-01-2022 12:30 | 27-01-2022 13:15 | 2 Weeks |  |  |  | 4
RUN 1 |  | Thursday | 27-01-2022 14:00 | 27-01-2022 14:45 | 1 Weeks |  |  |  | 1
RUN 1 |  | Thursday | 27-01-2022 14:45 | 27-01-2022 15:30 | 1 Weeks |  |  |  | 2
RUN 1 |  | Thursday | 27-01-2022 15:30 | 27-01-2022 16:00 | 1 Weeks |  |  |  | 3
RUN 1 |  | Thursday | 27-01-2022 16:00 | 27-01-2022 16:30 | 1 Weeks |  |  |  | 4
RUN 1 |  | Thursday | 27-01-2022 16:30 | 27-01-2022 17:00 | 1 Weeks
RUN 1 |  | Friday | 28-01-2022 08:00 | 28-01-2022 10:00 | 1 Weeks
RUN 1 |  | Friday | 28-01-2022 10:00 | 28-01-2022 12:00 | 2 Weeks
RUN 1 |  | Friday | 28-01-2022 12:00 | 28-01-2022 14:00 | 1 Weeks
RUN 1 |  | Friday | 28-01-2022 14:00 | 28-01-2022 15:00 | 1 Weeks
RUN 1 |  | Friday | 28-01-2022 15:00 | 28-01-2022 16:00 | 1 Weeks
RUN 1 |  | Friday | 28-01-2022 16:00 | 28-01-2022 17:00 | 1 Weeks
RUN 1 |  | Monday | 31-01-2022 10:30 | 31-01-2022 11:00 | 1 Weeks
RUN 1 |  | Monday | 31-01-2022 11:30 | 31-01-2022 12:00 | 4 Weeks
RUN 1 |  | Monday | 31-01-2022 14:45 | 31-01-2022 15:30 | 1 Weeks
RUN 1 |  | Monday | 31-01-2022 16:15 | 31-01-2022 17:00 | 1 Weeks
RUN 1 |  | Tuesday | 01-02-2022 10:15 | 01-02-2022 10:30 | 1 Weeks
RUN 1 |  | Tuesday | 01-02-2022 11:30 | 01-02-2022 12:00 | 1 Weeks
RUN 1 |  | Tuesday | 01-02-2022 12:30 | 01-02-2022 13:00 | 1 Weeks
RUN 1 |  | Tuesday | 01-02-2022 14:15 | 01-02-2022 14:30 | 4 Weeks
RUN 1 |  | Tuesday | 01-02-2022 14:30 | 01-02-2022 15:00 | 1 Weeks
RUN 1 |  | Tuesday | 01-02-2022 16:30 | 01-02-2022 17:00 | 1 Weeks
RUN 1 |  | Wednesday | 02-02-2022 08:30 | 02-02-2022 09:00 | 1 Weeks
RUN 1 |  | Wednesday | 02-02-2022 10:00 | 02-02-2022 11:00 | 1 Weeks
RUN 1 |  | Wednesday | 02-02-2022 16:00 | 02-02-2022 17:00 | 1 Weeks
RUN 1 |  | Thursday | 03-02-2022 10:00 | 03-02-2022 10:30 | 1 Weeks
RUN 1 |  | Thursday | 03-02-2022 11:00 | 03-02-2022 11:30 | 4 Weeks
RUN 1 |  | Thursday | 03-02-2022 11:30 | 03-02-2022 12:00 | 4 Weeks
RUN 1 |  | Thursday | 03-02-2022 13:00 | 03-02-2022 13:30 | 1 Weeks
RUN 1 |  | Thursday | 03-02-2022 13:30 | 03-02-2022 14:00 | 1 Weeks
RUN 1 |  | Thursday | 03-02-2022 14:30 | 03-02-2022 15:00 | 1 Weeks
RUN 1 |  | Friday | 04-02-2022 12:00 | 04-02-2022 14:00 | 1 Weeks
RUN 1 |  | Friday | 04-02-2022 16:00 | 04-02-2022 17:00 | 1 Weeks
RUN 1 |  | Monday | 07-02-2022 12:00 | 07-02-2022 13:00 | 4 Weeks
RUN 1 |  | Tuesday | 08-02-2022 11:00 | 08-02-2022 11:30 | 4 Weeks
RUN 1 |  | Tuesday | 08-02-2022 12:00 | 08-02-2022 12:30 | 4 Weeks
RUN 1 |  | Wednesday | 09-02-2022 11:00 | 09-02-2022 12:00 | 4 Weeks
RUN 1 |  | Thursday | 10-02-2022 10:30 | 10-02-2022 11:00 | 1 Weeks
RUN 1 |  | Thursday | 10-02-2022 13:00 | 10-02-2022 14:00 | 2 Weeks
RUN 1 |  | Thursday | 10-02-2022 14:00 | 10-02-2022 15:00 | 2 Weeks
RUN 1 |  | Monday | 14-02-2022 11:00 | 14-02-2022 12:00 | 1 Weeks
RUN 1 |  | Tuesday | 15-02-2022 13:00 | 15-02-2022 13:30 | 1 Weeks
RUN 1 |  | Thursday | 17-02-2022 11:15 | 17-02-2022 11:30 | 4 Weeks
RUN 1 |  | Thursday | 17-02-2022 13:00 | 17-02-2022 14:00 | 1 Weeks
RUN 1 |  | Thursday | 17-02-2022 16:00 | 17-02-2022 17:00 | 1 Weeks