Excel SEQUENCE Function for Dates: Examples and Tips

Formulas & functions · Updated November 19, 2026

In Excel for Microsoft 365, use =SEQUENCE(7,1,DATE(2026,4,1),1) to generate seven consecutive date values starting April 1, 2026. Format the spilled results as dates; SEQUENCE creates numbers, and Excel displays them as dates when the cells use a date format.

What SEQUENCE does with dates

SEQUENCE creates an array of numbers in a specified number of rows and columns. Its syntax is SEQUENCE(rows,[columns],[start],[step]): rows and columns set the array’s shape, start gives its first value, and step sets the amount added between values. For a date list, the start is usually a date value and the step is the number of days between dates.

Excel stores dates as serial numbers, with each whole number representing a day. For example, adding 1 to a date advances it by one day. A date entered with DATE is a reliable way to provide the starting value because it avoids ambiguity between regional date-entry formats. SEQUENCE does not have a special “date mode”; it generates the underlying numbers, and cell formatting controls how those numbers appear.

SEQUENCE is available in Microsoft 365 and Excel 2021 or later, including supported versions of Excel for the web and Mac. In Microsoft 365 for Windows, enter a formula in one cell and press Enter. Excel fills the neighboring cells automatically with the spilled array. The basic formula works the same way on Mac; ribbon labels and some keyboard shortcuts can differ, but no special date-generation command is required.

Generate daily dates

For a daily calendar, use a step of 1. With no input cells required—the starting date is written into the formula—the following creates seven dates from April 1 through April 7, 2026:

=SEQUENCE(7,1,DATE(2026,4,1),1)

The arguments request seven rows and one column, begin at April 1, and increase by one day each time. To create a longer list, change the first argument. To generate dates every two days, use a step of 2. The formula returns genuine date serials, so you can sort them, compare them with other dates, or use them in calculations—not just display date-looking text.

You can also make the sequence length depend on two worksheet cells. With the start date in A2 and the end date in B2, and both cells containing valid Excel dates, this formula returns every date from A2 through B2, including both endpoints:

=SEQUENCE(B2-A2+1,1,A2,1)

For example, if A2 is April 1, 2026 and B2 is April 7, 2026, the result is seven dates. The plus 1 makes the range inclusive. If the end date is earlier than the start date, the requested row count is invalid; check the inputs or add a separate check before relying on the formula.

Create monthly and other calendar intervals

A common mistake is to use a step of 30 to mean “one month.” Months have different lengths, so a 30-day sequence will drift away from calendar month boundaries. Use EDATE with a SEQUENCE of month offsets instead. With no input cells required, this returns the first day of each month in 2026:

=EDATE(DATE(2026,1,1),SEQUENCE(12,1,0,1))

SEQUENCE supplies the offsets 0 through 11, and EDATE moves the January 1 anchor forward by that many months. Starting on the first of a month makes the result easy to interpret. EDATE also adjusts dates that fall near the end of a shorter month, so anchoring on January 31 may not produce the last day of every month; use an end-of-month formula if that is what the calendar requires.

With no input cells required, this version produces each month’s final date in 2026:

=EOMONTH(DATE(2026,1,1),SEQUENCE(12,1,0,1))

For a weekly schedule, use a seven-day step. With no input cells required, this generates 12 dates one week apart, starting on January 5, 2026:

=SEQUENCE(12,1,DATE(2026,1,5),7)

That gives recurring dates on the same weekday, which can be useful for weekly reporting or appointment planning. It does not check whether a date is a holiday or a working day; those rules require a different approach.

List weekdays and account for holidays

SEQUENCE alone counts every calendar day, including Saturday and Sunday. To return working days, use WORKDAY, which skips weekends. With no input cells required, the next formula returns ten weekday dates beginning on January 1, 2026, if no holidays are supplied:

=WORKDAY(DATE(2026,1,1)-1,SEQUENCE(10))

Subtracting one from the start date sets up the first WORKDAY result to be the start date itself when it is a weekday. In this example, January 1, 2026 is a Thursday, so it is included. The result continues through the next weekdays and skips Saturday and Sunday.

To exclude listed holidays too, put holiday dates in H2:H20. With that layout, use:

=WORKDAY(DATE(2026,1,1)-1,SEQUENCE(10),$H$2:$H$20)

Make sure the holiday cells contain real Excel dates, not text that only looks like a date. WORKDAY uses Saturday and Sunday as the weekend by default. If your workweek uses different weekend days, WORKDAY.INTL lets you specify a weekend pattern; check its weekend-code options before choosing one. Also note that “business day” conventions vary, so make the weekend and holiday assumptions match the schedule you are building.

Format the spilled results as dates

If a sequence appears as numbers such as 46000 instead of familiar dates, the formula may be working correctly: those numbers are date serials. Select the spilled cells, then use Home > Number Format dropdown and choose Short Date or Long Date. You can also use Format Cells to select a date format or create a custom display, such as a weekday plus a day and month.

Formatting changes how a value looks, not the value itself. For instance, a date formatted to show only the month name is still a full date that can be used in date arithmetic. Conversely, a string created with TEXT may look like a date but is text, which can cause problems when another formula expects a date value. Keep dates as serial values for calculations and apply cell formatting for presentation whenever possible.

If the output is in a single cell, check the formula’s row and column arguments. If the dates are in adjacent cells but not displayed as dates, apply a date format to the entire spill range. You can select the starting formula cell and refer to the spilled range with the # operator in compatible Excel versions—for example, A1# refers to the full array originating in A1.

Understand spill behavior and common errors

Dynamic arrays need empty worksheet cells in which to display their results. If any cell in the intended spill area contains data, Excel shows a #SPILL! error. Clear or move the blocking content, and check for merged cells or other obstructions in the destination area. The formula itself belongs in just the first cell; do not copy it down as if it were a traditional one-row formula.

Spilled formulas cannot expand inside an Excel table in the same way they do in a normal worksheet range. Place the SEQUENCE formula outside the table, or use a different design if the results must be table rows. Also check that the requested spill range fits within the worksheet and that the row count is a positive whole number.

  • Numbers instead of dates: Apply a date number format to the results.
  • #SPILL!: Remove entries or merged cells blocking the output range.
  • Unexpected month dates: Use EDATE or EOMONTH rather than a fixed 30-day step.
  • Dates read incorrectly: Use DATE(year,month,day) or verify that input cells contain actual dates.
  • Function not recognized: Confirm that the Excel version supports dynamic arrays and SEQUENCE.

When SEQUENCE is the right tool

SEQUENCE is especially useful when you want a predictable, spillable list whose length or interval can be changed in one formula. It avoids filling dates manually and can be combined with functions such as EDATE, EOMONTH, or WORKDAY to represent calendar rules. It is a good fit for a timeline, a date axis for a chart, or the date portion of a planning sheet.

It is not automatically the best choice for every date list. If you need a fixed set of dates that will never change, typing or pasting values may be simpler. If you need a complex schedule—such as different holidays by region, rotating shifts, or dates that depend on event records—formulas built around WORKDAY.INTL, filters, or a source table may suit the rules better. A formula that creates dates does not verify that those dates match an organization’s business calendar.

In Microsoft 365 on Windows, SEQUENCE spills from its formula cell. Older Excel versions without dynamic arrays may not support the function. For compatibility with older workbooks, a traditional formula filled down can generate dates instead, but it requires copying the formula into the needed rows and is less convenient when the number of dates changes. Excel for Mac and the web support dynamic arrays in compatible versions, though the application interface can vary.

Frequently Asked Questions

Can Excel SEQUENCE generate dates?
Yes. Give SEQUENCE a valid Excel date as its start and a day increment as its step. Format the returned serial numbers as dates so they display in a readable date format.

How do I make a sequence of dates for a whole month?
Use SEQUENCE with the number of days in the month as its row count and the first day as its start. For a month whose length varies, use a formula based on the month’s start and end dates rather than assuming every month has 30 or 31 days.

Can SEQUENCE create dates for every month?
Yes. Combine it with EDATE, using offsets from 0 upward and a first-of-month anchor. Use EOMONTH instead when you want the last date of each month.

Why does my date sequence show large numbers?
Excel stores dates as serial numbers. Select the result cells and choose a date format from Home > Number Format dropdown; the underlying date values remain usable in calculations.

Can SEQUENCE skip weekends?
Not by itself: a step of 1 includes every calendar day. Combine a sequence of workday offsets with WORKDAY to skip standard weekends, and provide a holiday range if those dates should be excluded too.

Does SEQUENCE work in older Excel versions?
SEQUENCE is available in Microsoft 365 and Excel 2021 or later, but not in many older perpetual versions. In an unsupported version, use a formula filled down or another method that does not require dynamic arrays.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.