Dynamic ArrayLevel: ExpertAvailable in: Excel 365 / 2021+
In this article
- Syntax
- Examples
- Example 1
- Example 2
- Example 3
- Related functions
SEQUENCE creates a spilled list of numbers — serial numbers, calendars, repeating patterns.
Syntax
=SEQUENCE(rows, [columns], [start], [step])
| Argument |
What it means |
rows, columns |
Size of the result. |
start, step |
First value and increment. |
Examples
Example 1
=SEQUENCE(10)
1 to 10 down a column.
Example 2
=SEQUENCE(12, 1, DATE(2025,4,1), 31)
Approximate month starts (wrap in EOMONTH for exact ones).
Example 3
=EOMONTH(DATE(2025,3,1), SEQUENCE(12))
The 12 month-ends of FY 2025–26.
RANDARRAY · ROW · EOMONTH
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong