Sequence of months

To generate a series of dates incremented by month, you can use the SEQUENCE function together with the EDATE function. In the example shown, the formula in D5 is: =EDATE(B5,SEQUENCE(12,1,0)) The result is a series of 12 dates, incremented by one month, beginning on June 1, 2023. Note: in the generic version of the formula above, 'n' is the number of dates you wish to generate. In this example, n is 12, since we want 12 dates.

April 14, 2025 · 1 min · 95 words · Timothy Thornton

Table of Contents

For more details on EDATE, see:How to use the EDATE function.

SEQUENCE function

The SEQUENCE function is designed to generate numeric sequences in rows and/or columns.

For more details on SEQUENCE, seeHow to use the SEQUENCE function.

Dates by month in legacy Excel

The format “mmmm” tells the TEXT function to extract the full month name from a given date.

Older versions of Excel

In older versions of Excel, there is no SEQUENCE function.

This means we don’t have an easy way to calculate and return 12 dates all at once.

Dates by month in legacy Excel

The array can be one dimensional, or two-dimensional, determined byrowsandcolumnsarguments.

Dates by month in legacy Excel

Dates by month in legacy Excel

Dates by month in legacy Excel

Excel formula: Sequence of days

Excel formula: Sequence of workdays

Excel formula: Sequence of years

Excel formula: List workdays between dates

Excel SEQUENCE function

Excel EDATE function

Excel EOMONTH function