Excel SEQUENCE: Generate Number Series
SEQUENCE Function is a Excel function that sequence(12, 1, 0, 1) generates 12 numbers: 0, 1, 2... Formula Genius generates and validates this formula automatically from a plain-English prompt.
SEQUENCE creates dynamic arrays of numbers. Build date ranges, row numbers, time slots, and matrix scaffolding without typing.
The Formula
"Generate a list of the next 12 month-end dates starting from today"
=EOMONTH(TODAY(), SEQUENCE(12, 1, 0, 1))SEQUENCE(12, 1, 0, 1) generates 12 numbers: 0, 1, 2... 11. EOMONTH uses each number as a month offset from TODAY(), returning the end date of this month, next month, etc.
Step-by-Step Breakdown
- SEQUENCE(rows, [cols], [start], [step]) generates a number array
- 12 rows, 1 column, starting at 0, incrementing by 1
- Produces: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11
- EOMONTH(TODAY(), n) gets end-of-month n months from now
- Result: 12 month-end dates spilling downward
Edge Cases & Warnings
- Results spill — clear enough cells below for the full sequence
- Format cells as Date to see dates instead of serial numbers
- SEQUENCE(5, 3) creates a 5x3 grid — useful for matrix scaffolding
- Requires Excel 365 or Excel 2021+
Examples
"=SEQUENCE(5)"
1, 2, 3, 4, 5"=SEQUENCE(3, 3, 1, 1)"
3x3 grid: 1-9"=DATE(2026,1,1)+SEQUENCE(7,1,0,1)"
7 consecutive dates from Jan 1Frequently Asked Questions
How do I generate a list of dates?
=DATE(year, month, day) + SEQUENCE(count, 1, 0, 1). Change the step to 7 for weekly dates, 30 for approximately monthly.
Can SEQUENCE create column headers?
Yes. =SEQUENCE(1, 12, 1, 1) creates a horizontal 1-12 row. Combine with TEXT and DATE for month names.
Can't find what you need?
Describe any formula in plain English and Formula Genius will generate, explain, and validate it — instantly.