In Excel for Microsoft 365 on Windows, enter =SEQUENCE(10,1,DATE(2026,1,1),1) in an empty cell to create ten consecutive daily dates beginning January 1, 2026. Format the spilled results as dates if they appear as numbers; for a quick sequence without a formula, enter the first two dates, select both cells, and drag the fill handle.
What a date sequence is
A date sequence is a series of date values arranged in order, usually in a column or row. It might contain every calendar day, only weekdays, the first day of each month, or a custom interval such as every 14 days. Sequences are useful for calendars, project schedules, timesheets, sales reports, and chart axes. The important distinction is that Excel dates are stored as numeric values, not as text labels. That lets you sort dates chronologically, calculate the number of days between them, and use date-aware formulas.
The display is controlled separately from the stored value. A cell may contain the date value for January 1, 2026, while Excel displays it as 1-Jan-26, 01/01/2026, or simply a number if its format is General. Changing the display format does not change the underlying date or the spacing between dates.
Create a sequence with SEQUENCE
SEQUENCE is the most direct method when you know how many dates to generate. It is available in Microsoft 365 and Excel 2021 or later. With cell B2 empty and enough room below it for ten results, enter =SEQUENCE(10,1,DATE(2026,1,1),1). It returns ten values in one column, beginning January 1, 2026 and ending January 10, 2026. The four arguments mean rows, columns, starting value, and step. Change the first argument to change the number of dates, the second to 1 for a column or to another number for multiple columns, and the last argument to set the interval.
For instance, with B2 empty and room for five dates, =SEQUENCE(5,1,DATE(2026,1,1),7) returns January 1, 8, 15, 22, and 29, 2026. The increment is seven date serial numbers, so this creates a weekly cadence on the same weekday. If Excel displays serial numbers instead of calendar dates, select the results and choose a date format from Home > Number Format. The formula spills into neighboring cells; if any destination cell is occupied, Excel reports a spill error and cannot display the full sequence.
Choose a daily, weekly, or custom interval
For a daily sequence, use a step of 1. For every other day, use 2; for a weekly sequence, use 7. If the sequence should run horizontally, make the column argument 10 instead of the row argument. With C2 empty and room across ten columns, =SEQUENCE(1,10,DATE(2026,1,1),1) produces ten consecutive dates in one row.
SEQUENCE uses a fixed number of results rather than stopping at a date you specify. If you need an end date, work out the number of intervals first, or use Fill Series, which can stop at a specified value. For a daily sequence from January 1 through January 31, inclusive, there are 31 dates. With D2 empty, =SEQUENCE(31,1,DATE(2026,1,1),1) returns that complete month. Make sure the number of rows matches the desired inclusive range: omitting an endpoint is a common reason a list is one date too short.
Use the fill handle for a quick list
The fill handle is convenient when you want a short sequence and prefer not to enter a formula. Type the first date in A2 and the next date in A3. Select A2:A3, then drag the small square at the selection’s lower-right corner down or across. Excel recognizes the one-day pattern and continues it. For a weekly series, enter dates seven days apart in the first two cells before dragging. Selecting only one date and dragging may copy that date rather than create the intended pattern, so seed the pattern with two dates when you want Excel to infer an interval.
You can also use the ribbon: select the starting cell or the range to fill, then choose Home > Fill > Series. In the Series dialog, choose Rows or Columns, select Date as the type, choose a date unit such as Day, Weekday, Month, or Year, and enter a step value and stop value. For example, a column series with Date selected, Day as the date unit, a step value of 1, and a stop value of January 31, 2026 creates daily dates through that endpoint. The dialog is useful when you know the stopping date but not the number of entries.
Build a sequence by adding to the previous date
A simple formula is useful when the next date should depend on the previous row and you want to copy the calculation down. With the starting date in A2 and A3 as the next row, enter =A2+1 in A3, then copy or fill that formula down. If A2 contains January 1, 2026, A3 returns January 2, 2026, and each copied row adds one more day. To create weekly dates instead, use =A2+7 in A3 and fill down; the next result is January 8, 2026.
On Windows, select the formula cell and the cells below it, then press Ctrl+D to fill down. On Mac, use Command+D. You can also copy and paste or drag the fill handle. Unlike a SEQUENCE formula, each copied formula refers to the date immediately above it. That can be helpful if you later change the starting date, but it also means deleting or changing an intermediate row may affect the chain below it.
Create weekday-only and month-end sequences
Adding 1 includes Saturdays and Sundays. To list working days and skip weekends, enter a starting date in A2, then put =WORKDAY(A2,1) in A3 and fill down. If A2 is Friday, the next result is Monday, assuming Monday through Friday are the working days. WORKDAY can also exclude holidays, but you must provide the holiday dates as a range. With the first date in A2 and holiday dates in H2:H10, use =WORKDAY(A2,1,$H$2:$H$10) in A3, then fill down. The result is the next workday that is not in the listed holiday range. Check that holiday cells contain actual Excel dates, not text that merely looks like dates.
Monthly sequences need a little more care because months have different lengths. With the first date in B2 and the next row in B3, =EDATE(B2,1) advances one month while retaining the day number when possible. If B2 is January 31, 2026, the result is February 28, 2026. Repeating EDATE from that result will produce March 28, not March 31. If you want the last calendar day of every month, enter January 31 in B2 and use =EOMONTH(B2,1) in B3, then fill down. That returns February 28, followed by March 31. EOMONTH is also useful for month-end reporting periods.
Format and check the results
To make a generated sequence readable, select its cells and use Home > Number Format to choose Short Date, Long Date, or a custom format. A custom format such as yyyy-mm-dd makes dates sort clearly in exported files and avoids ambiguity between regional conventions such as month/day/year and day/month/year. The format changes how the value appears, not the date itself. Avoid converting dates to text unless a text label is specifically required, because text dates may not sort or calculate as expected.
Check a sequence by comparing its first and last values, counting the populated cells, and confirming the interval. For a daily series, the difference between neighboring date values should be 1; for a weekly series, it should be 7. You can temporarily set a cell to General to see the underlying serial number, but return it to a date format for normal use. When a formula returns an unexpected result, verify that the starting cell is a real date value and that the sequence’s step and count match the requested range.
Common problems and date-system context
If a SEQUENCE formula displays a number such as 46023, the date calculation may be correct but the cells are formatted as General or Number. Apply a date format. If Excel shows #SPILL!, clear cells in the intended output area or move the formula to a location with enough empty space. If the formula is treated as text, check that the cell is not formatted as Text and that the entry begins with an equals sign. If a manually typed date is interpreted as a different month and day, regional date settings may be affecting how Excel reads it; a DATE function with separate year, month, and day arguments avoids that ambiguity.
Excel stores dates as serial numbers and uses a workbook date system to interpret them. Most current Windows workbooks use the 1900 date system; some older Mac workbooks may use the 1904 system. The two systems differ by 1,462 days, which can make dates appear offset when values are transferred between workbooks configured differently. This is unusual in ordinary use, but relevant when combining older files. The 1900 system also preserves a historical compatibility quirk involving a fictitious February 29, 1900, so avoid building modern date logic around dates near the beginning of that system.
Choose the method that fits the task
Use SEQUENCE when you want a formula-driven list with a known number of rows and have Microsoft 365 or Excel 2021 or later. It is compact and updates automatically if its arguments change. Use the fill handle for a quick pattern inferred from two starting dates, or Home > Fill > Series when you want to specify a stopping date and date unit. Use addition, WORKDAY, EDATE, or EOMONTH when each next value must follow a specific rule, especially if the list depends on a starting cell or should skip weekends or land on month-end.
Excel for the web supports dynamic array formulas such as SEQUENCE, although the ribbon and fill interactions can differ from the Windows desktop. On Mac, the same basic formula methods work in current Excel versions, while keyboard shortcuts differ; Command+D fills down where Windows uses Ctrl+D. If a workbook will be shared with someone using an older Excel release, confirm that their version supports SEQUENCE. A filled series or a copied formula may be a more compatible choice for recipients who cannot use dynamic arrays.
Frequently Asked Questions
How do I autofill dates in Excel?
Enter two dates that show the desired interval, select both cells, and drag the fill handle. For a daily series, use consecutive dates; for weekly dates, use dates seven days apart. You can also use Home > Fill > Series to set the date unit and stopping date.
How do I make a date sequence without weekends?
Put the starting date in A2, enter =WORKDAY(A2,1) in A3, and fill down. To skip holidays too, list the holiday dates in a range and supply that range as WORKDAY’s third argument. The standard WORKDAY function treats Saturday and Sunday as weekends.
Why does my date sequence show numbers?
Excel dates are stored as serial numbers. Select the results and apply a date format from Home > Number Format. If the values still look wrong, confirm that the starting value is a real date rather than text.
How do I create a sequence for every month?
For the same day of each month where possible, use EDATE on the previous date and fill down. For the last day of each month, use EOMONTH instead. These rules differ around short months: a sequence beginning on January 31 will not keep returning the 31st if you repeatedly use EDATE.
Can I create a date sequence between two dates?
Yes. Use Home > Fill > Series and set the stop value, or calculate how many dates belong in the inclusive range and use that as SEQUENCE’s row count. Remember that an inclusive daily range contains both endpoints, so a January 1 to January 31 sequence has 31 entries.
Related
- Customer Details in Excel: How to Set Up a Useful List
- Customizable Calendar Template in Excel: How to Make One
- Ctrl+H in Excel: Find and Replace Step-by-Step Guide
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Extract Dates From Text in Excel: Formulas and FixesTo extract a date from text in Excel for Microsoft 365, isolate the date text and convert it…
- Packing List Excel With Formula: Build a Smart ChecklistYes. In an Excel packing list, put each item in column A and its packing status in column…
- Trim Excel Data: Remove Extra Spaces the Right WayTo remove extra spaces in Excel, enter =TRIM(A2) in a helper column, replacing A2 with the cell you…
- Excel Payment Schedule: Build One With FormulasTo build a basic loan payment schedule in Excel, enter the annual interest rate, number of monthly payments,…
- Excel Formula Between Two Numbers: ExamplesTo check whether a value in A2 is between a lower limit in B2 and an upper limit…
- Excel XLOOKUP and Power Query: How They Work TogetherExcel XLOOKUP and Power Query work together, but they do different jobs: Power Query imports, cleans, and combines…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.