We largely use the fill deal with or auto-fill choices for date columns, and certain, they work. However when you want a whole lot of rows, weekly intervals, or dates that must shift when your knowledge adjustments, dragging cells stops being sensible. SEQUENCE handles all of this with one system. It generates a complete dynamic column of dates — consecutive, weekly, month-to-month, regardless of the challenge requires — and updates itself for those who change the beginning date or step worth.
Associated
Excel lastly fastened its greatest knowledge entry downside, and it is a lifesaver
One click on within the Information tab can catch virtually all points.
SEQUENCE builds a date column from a system
Here is how the syntax and output work
SEQUENCE is a dynamic array operate that spills a collection of values into adjoining cells routinely. You give it a place to begin, inform it what number of values to generate, and it fills the remaining. Due to this fact, you need not drag, copy, or manually enter. One system does what used to take a number of steps.
Here is the syntax:
=SEQUENCE(rows, [columns], [start], [step])
- rows: The variety of values to generate vertically. In the event you want 30 dates, that is 30.
- columns: It is non-obligatory and defaults to 1. You’d solely change this if you would like a grid of values fairly than a single column, which is uncommon for date work.
- begin: The primary worth within the collection. For dates, you will need to use the DATE operate right here (e.g., DATE(2025,1,1)) fairly than typing a date immediately, since SEQUENCE works with numbers.
- step: The interval between every worth. A step of 1 provides you consecutive days, 7 provides you weekly dates, and so forth.
So a system like =SEQUENCE(12, 1, DATE(2026,1,1), 1) generates 12 consecutive dates beginning January 1, 2026. The output spills into 12 cells under the system cell by itself.
One factor that journeys individuals up is that SEQUENCE outputs serial numbers, not formatted dates. Excel shops dates internally as numbers, so you will see values like 46023 as an alternative of January 1. Simply format the cells as Brief Date, and also you’re good. The underlying knowledge is appropriate; it is purely a show situation.
What makes this value utilizing over the fill deal with is that the output is dwell. If you change the beginning date or step worth, each cell within the spilled vary updates immediately. Fill deal with can acknowledge patterns (e.g., weekly from two cells), however requires guide re-drag on adjustments, not like SEQUENCE.
That is the place SEQUENCE pulls forward of the fill deal with. With static values, altering a begin date means redoing your complete column. Deleting a row leaves a spot that will not shut by itself, and dragging weekly dates requires Excel to appropriately guess your sample from two pattern cells. SEQUENCE sidesteps all of that — one system controls the beginning, interval, and size, and any edit you make propagates by means of your complete vary instantly.
SEQUENCE handles extra than simply consecutive days
Weekly, month-to-month, and quarterly dates are only a step worth away
Every day dates are the plain use case, however SEQUENCE will get extra helpful when you begin adjusting the step worth. A step of seven provides you weekly dates — helpful for scheduling recurring conferences or monitoring weekly reviews. A step of 14 covers biweekly intervals, which is what you’d need for payroll schedules or dash planning.
Month-to-month dates are the place issues get barely tough. Months haven’t got equal lengths, so setting a step of 30 will not land you on the identical day every month. February alone would throw the entire column off. The workaround is to pair SEQUENCE with the EDATE operate, which shifts a date ahead by a particular variety of months no matter what number of days every month has. The system appears like this:
=EDATE(DATE(2026,1,1), SEQUENCE(12,1,0,1))
This generates the first of each month from January by means of December 2026. SEQUENCE produces the numbers 0 by means of 11, and EDATE makes use of every one to offset the beginning date by that many months. The result’s twelve clear, evenly spaced month-to-month dates.
You may as well use SEQUENCE to generate time intervals. Since Excel treats time as fractions of a day, a step of 1/24 produces hourly timestamps, and 1/48 provides you half-hour slots. That is helpful for creating appointment schedules or shift rosters with out having to sort every time slot individually. Simply format the output cells as Time as an alternative of Date.
One other sensible instance is quarterly dates. Set the step within the EDATE system to three as an alternative of 1, and you will get Q1 by means of This autumn begin dates for any yr. Fiscal reporting, assessment cycles, tax deadlines, something that runs on a quarterly rhythm slots proper in with minimal effort.
The sample right here is easy, so no matter interval your challenge wants, SEQUENCE can in all probability generate it. You simply must assume by way of steps and offsets.
Pair SEQUENCE with different capabilities
These combos push it additional
When you’re comfy producing date columns, attempt nesting SEQUENCE inside WORKDAY to skip weekends routinely — helpful for challenge timelines that solely depend enterprise days. You may as well feed SEQUENCE into conditional formatting guidelines to spotlight overdue dates or upcoming deadlines with out constructing separate helper columns.
For one thing extra superior, mix it with FILTER to tug solely dates that fall on a particular weekday, or wrap it in TEXT to output formatted strings like “Jan 2026” immediately. The operate pairs properly with virtually something.
