On-Call Issue Employee

crown

Update the output cells to display which employee was on-call for each issue based on the issue date and the on-call rotation schedule table in columns F:G. Every month, an employee is on-call starting on their start day and remains on-call until the day immediately before the next employee's start day. The last employee listed is on-call until the last day of each month. The schedule table is sorted in ascending order by start day and always begins with 1. See Examples

Your solution should use cell references so it updates automatically if the input cells change values.

A1
fx

This cell cannot be edited

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50