Quick Answer & Formula
Excel
Sheets
Beginner
=SEQUENCE(rows, [columns], [start], [step]) SEQUENCE creates an array of sequential numbers. For 10 consecutive rows: =SEQUENCE(10). For dates starting today for 30 days: =SEQUENCE(30, 1, TODAY(), 1).
SEQUENCE Function in Excel & Google Sheets
The SEQUENCE function generates a dynamic list or 2D matrix of sequential numbers or dates with a single formula, eliminating the need to drag the fill handle.
1. Generating a Numbered List (1 to 100)
=SEQUENCE(100)2. Generating the Next 30 Calendar Days
=SEQUENCE(30, 1, TODAY(), 1)(Format the output cells as Short Date)
3. Creating Evenly Spaced Milestones (e.g. 100 to 1,000 by 100s)
=SEQUENCE(10, 1, 100, 100)- Returns:
100, 200, 300, 400... 1000.
?
Frequently Asked Questions
How do I generate a list of monthly dates for a 12-month budget?
Combine EDATE with SEQUENCE: =EDATE(DATE(2026,1,1), SEQUENCE(12, 1, 0, 1)).