2)

The current year end is 31 December 2021 and this date appears in cell E5 alongside other key inputs to the model. We would like a succession of 10-year end dates to appear in row 2 starting from E2:

E2 should show 31 December 2021

F2 should show 31 December 2022

G2 should show 31 December 2023, etc.

Row 1 has a succession of counters starting at 0 in E1, 1 in F1, 2 in G2, etc.

What is the most flexible formula which should appear in E2 (note most of the following formulae give the same result)?

=E5+E1*365

=EDATE($E$5,E1*12)

=EDATE($E$5,E1*365)

=EDATE($E$5,0)