Explanation
The goal is to generate a series of dates one year apart.
Both methods are described below.
SEQUENCE function
TheSEQUENCE functiongenerates numeric arrays.
Themonthis provided as 5 anddayis provided as 1.
Then it adds 1 to the year value and returns the results to theDATE functionwhich creates a new date.
The reason we do this is to maintain the workbook structure, with the start date in cell B5.
It’s a good example of how thedynamic arraycreated by SEQUENCE provides a more compact, elegant solution.
As the formula is copied down, it returns a series of dates incremented by one year.
The array can be one dimensional, or two-dimensional, determined byrowsandcolumnsarguments.
YEAR Function
The Excel YEAR function returns the year component of a date as a 4-digit number.
