To generate a series of dates incremented by month, you can use the SEQUENCE function together with the EDATE function or EOMONTH function. In the example shown, the formula in D5 is:

{=EDATE(B5,SEQUENCE(12,1,0))}

which outputs a series of 12 dates, incremented by one month, beginning on May 1, 2019.

Note: this is an array formula and must be entered with control + shift + enter.

How this formula works

The EDATE function moves forward or backwards in time in one-month increments from a given start date. The SEQUENCE function is a dynamic array function that can generate multiple results that “spill” onto the worksheet in a “spill range”.

SEQUENCE can generate results in rows, columns, or both. In this case, SEQUENCE is configured to output an array of numbers that is 12 rows by 1 column:

SEQUENCE(12,1,0)

The start is zero, and step value defaults to 1, so SEQUENCE outputs an array like this:

{0;1;2;3;4;5;6;7;8;9;10;11}

This array is returned to as the months argument inside the EDATE function. EDATE then returns 12 dates, beginning with the date in B5. Excel dates are stored as serial numbers, so the output looks like this:

{43586;43617;43647;43678;43709;43739;43770;43800;43831;43862;43891;43922}

When these results are formatted as dates, the result is 12 dates incremented by one month, beginning May 1, 2019.