Function reference

SEQUENCE in Excel & Google Sheets

SEQUENCE is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.

1 beginnerBuild a custom SEQUENCE formula →

When to use SEQUENCE

Auto-number a list of items, generate a series of month numbers from 1 to 12, or create a row index for XLOOKUP or other formulas.

Worked examples (1)

Array Formulasbeginner

Generate a number sequence with SEQUENCE

=SEQUENCE(10)

Open formula SEQUENCE reference

Common errors with SEQUENCE

SEQUENCE is not available

SEQUENCE requires Excel 365 or Excel 2021. Use ROW()-ROW($A$1)+1 as a workaround in older versions.

SPILL error

SEQUENCE needs empty cells to spill into. Clear the destination range and the formula will resolve.

Frequently asked questions

How do I generate a series of dates?

Use SEQUENCE with a date start and a step of 1 — =SEQUENCE(30,1,DATE(2026,1,1),1) generates 30 consecutive dates starting January 1, 2026. Format the cells as dates.

Need a custom variation?

Describe your specific SEQUENCE problem and get a formula written for your exact data.

Open generator with SEQUENCE