Birth Date Cohort

crown

Update the output cells to display each person's birth date cohort number. This number is computed by first adding together their birth year, birth month, and birth day from their birth date (ex: 2006+12+13 for 12/13/2006), then dividing that total by 5 and returning only the remainder (a whole number between 0 and 4). 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