Intro Renewal Dates

crown

This intro problem practices EDATE. EDATE moves a date forward or backward by a specified number of whole months while keeping the same day number when that day exists in the resulting month or keeping the last day of the resulting month otherwise. Update the output cells so each row shows its renewal date. See Examples

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

Need help with EDATE details and syntax? Review the EDATE function guide first.

EDATE
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