Follow Up Date Code

crown

Update the output cells to display the follow up date code for each department. To determine a department's follow up date code, first find the ticket for that department with the earliest open date where the status equals "Open" in the table in columns E:H. Then compute the follow-up date as exactly 3 working days after that date. Working days are every day except Saturdays and Sundays. Finally, display that follow-up date as an 8-digit text code in the format yyyymmdd (example: 20260213). If a department has no tickets with an "Open" status, display "None". 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