How to Add a Sequence of Dates in Excel: 3 Easy Ways

Formulas & functions · Updated November 20, 2026

To add a sequence of dates in Excel, enter a starting date and the next date in two adjacent cells, select both, then drag the fill handle to continue the pattern. For example, with a start date in A2 and the following day in A3, Excel can fill a daily list down the column. You can also use the Series command or a formula, depending on whether you want a quick fill, a fixed range, or a sequence that updates automatically.

What You’ll Need

  • A workbook in Excel for Microsoft 365 on Windows. The fill handle and basic date formulas also work in current Excel for Mac and Excel for the web; ribbon options can vary slightly by platform.
  • A starting date, and a clear idea of the interval you need: every day, every week, working days only, or another pattern.
  • For a formula-generated list, an empty range where the results can appear. In particular, the SEQUENCE formula needs clear cells below it to display its results.

Step-by-Step

  1. Enter a starting date. Click the first cell for your list, such as A2, and type a date Excel recognizes, such as 1/1/2026. Press Enter. If Excel displays the value as a number, that is usually its date serial number; you can apply a date format later. To avoid ambiguity between regional date styles, you can type a date in a format your system recognizes or choose a date from the calendar picker when available.
  2. Set the interval with two example dates. For consecutive calendar days, type the next day in the cell below. For instance, enter January 1 in A2 and January 2 in A3. For weekly dates, enter January 1 and January 8 instead. These two values show Excel the step size, so it can continue the pattern rather than copying one value repeatedly. Check that the second date is the interval you actually want before filling hundreds of rows.
  3. Fill the pattern with the handle. Select both example cells, A2:A3. Point to the small square at the lower-right corner of the selection until the pointer becomes a plus sign, then drag down to the last row you need. Release the mouse button. Excel continues the interval through the selected cells. In Excel for Mac, the fill handle works in much the same way; on a trackpad, drag carefully from the small corner square. Excel for the web also supports dragging the handle in a browser.
  4. Check the Auto Fill choice. After dragging, Excel may show an Auto Fill Options button near the filled range. Choose Fill Days if you want every calendar day, or choose Fill Series to continue the pattern. If you want a list of weekdays only, choose Fill Weekdays when that option is available. The button may disappear after you click elsewhere, but you can undo with Ctrl+Z on Windows or Command+Z on Mac and repeat the fill if needed.
  5. Use the Series command for a specific range. Enter the first date in A2, select the cells you want to fill, such as A2:A31, then choose Home > Fill > Series. In the Series dialog, choose Columns if your dates run down the sheet, select Date as the type, and choose a date unit such as Day. Enter a step value of 1 for daily dates or 7 for weekly dates, then select OK. On some Mac builds, the command may appear under Home > Fill or in the menu bar’s Fill options. If you cannot find it, use the fill handle instead. The Series dialog is not available in every Excel interface, including some web experiences.
  6. Generate a list with SEQUENCE. If A2 contains the starting date and you want ten consecutive dates, enter this in B2: =SEQUENCE(10,1,A2,1). It returns ten values in one column, starting with the date in A2 and increasing by one day each time. SEQUENCE is available in Microsoft 365 and Excel 2021 or later. The formula creates date serial values, so select the results and apply a date format if they appear as numbers. Leave the cells below B2 empty so the formula can spill its results into them.
  7. Format and verify the finished list. Select the dates, then choose Home > Number Format and select a suitable date style, such as Short Date. Confirm the first and last dates and spot-check a few rows in between. If the list ends on a particular date, count the number of intervals, not just the number of dates: a 10-date daily list includes the starting date and spans 9 one-day intervals.

For a simple formula-based fill, type the starting date in A2 and enter the next-day formula in A3: =A2+1. Then use the fill handle on A3 to copy the formula downward. Each row adds one to the date serial value in the cell above. This is useful when you need the date list to recalculate if the starting date changes, while the Series command and a manually filled list are often convenient for a one-time sequence.

To make a different interval with a formula, keep the starting date in A2 and enter the following in A3 for a weekly sequence: =A2+7. Fill that formula downward. The next cell will be seven days after the preceding date. Change 7 to another positive number for a different number of calendar days between entries.

For dates on the same day of each following month, with the first date in A2, enter this in A3: =EDATE(A2,1). Fill downward to continue monthly. EDATE moves by calendar months; if the starting date is near the end of a month, a month with fewer days can change the day number. For example, adding one month to January 31 returns the last valid day in February, rather than creating an invalid February 31.

For weekdays only, with a starting date in A2, enter this in A3: =WORKDAY(A2,1). Fill down to skip Saturdays and Sundays. If your holiday dates are listed in H2:H10, use =WORKDAY(A2,1,$H$2:$H$10) in A3 instead; the dollar signs keep the holiday range fixed as you copy the formula. WORKDAY treats the date in A2 as the starting point and returns the next working day, so test the first few results against your calendar, especially around holidays.

Common Mistakes

  • Selecting only one example date for a custom interval. A single date does not clearly establish a weekly or two-day pattern. Excel may copy the same date or use a default fill behavior. Enter two dates that demonstrate the intended spacing, select both, and fill again.
  • Typing dates as text. A date that looks right may be stored as text if it has an apostrophe at the beginning, includes an unrecognized format, or was imported from another system. Text dates may not increment correctly. Try changing the cell format to Short Date; if it stays unchanged or aligns unexpectedly, convert the text to real dates before filling.
  • Choosing calendar days when you meant working days. Adding 1 or using Fill Days includes weekends. Use Fill Weekdays or the WORKDAY function when Saturdays and Sundays should be skipped. Add a holiday list to WORKDAY if those dates must also be excluded.
  • Forgetting that formulas spill. A SEQUENCE formula cannot display all its results if cells in the output range already contain data, merged cells, or other obstructions. Clear the intended output cells before entering the formula.
  • Confusing display format with the underlying value. Excel stores dates as numbers. A date showing as 46023 is not necessarily broken; it may simply have a General or Number format. Apply a date format rather than retyping the value.

Tips

  • Estimate the number of rows first. A daily list for a month may need 28 to 31 dates, while a full calendar year needs 365 or 366. Include the start date when deciding how many cells to fill. In a leap year, February has 29 days.
  • Use the fill handle for quick lists and formulas for reusable lists. A filled date sequence is straightforward for a fixed schedule. A formula linked to a start-date cell is easier to update later; change the starting date and the dependent dates can adjust.
  • Make the pattern visible before filling. Two sample dates are usually enough for a steady interval. For a more complex pattern, enter several examples and select all of them before dragging, then inspect the continuation carefully.
  • Keep real dates separate from labels. If you need a heading such as Monday, type it in a separate header row or use a date display format. Avoid adding words directly to date cells if you plan to sort, filter, or calculate with them.
  • Choose a clear date display. Short dates take less space, but can be ambiguous across regions. A format that displays the month name, such as 1-Jan-2026, makes a shared worksheet easier to interpret. Formatting changes how the date looks, not the stored date value.

Troubleshooting

The same date repeats instead of increasing. Undo the fill, enter a second example date that shows the intended interval, and select both dates before dragging. If you already used two dates, click the Auto Fill Options button and choose Fill Series or the appropriate date option.

The cells show numbers instead of dates. Select the affected cells and choose Home > Number Format > Short Date. If the number changes to a date, the values are valid Excel dates. If the display does not change, the entries may be text; check for a leading apostrophe, spaces, or a date order that does not match your computer’s regional settings.

The sequence skips an unexpected number of days. Check the sample dates and the step value. A difference of 7 between the first two dates creates weekly intervals, while a step value of 1 in the Series dialog creates daily intervals. Also confirm that you selected the intended Auto Fill option; Fill Weekdays skips weekends.

SEQUENCE returns a spill error or only part of the list appears. Clear cells in the expected output area, unmerge any merged cells in that area, and make sure the formula is not inside an Excel Table where dynamic arrays may be restricted. Confirm that you are using Microsoft 365 or Excel 2021 and later; earlier versions may not support SEQUENCE. If you need a compatible alternative, enter a start date and use the =A2+1 method described above.

The dates change when you did not expect them to. Check whether the cells contain formulas linked to another date. If you need a fixed list, copy the results and use Home > Paste > Paste Values to replace formulas with their current values. Do this only after confirming the dates are correct.

Frequently Asked Questions

Can Excel fill dates without weekends?
Yes. Use the fill handle’s Fill Weekdays option when available, or use WORKDAY in a formula. WORKDAY skips Saturday and Sunday; include a holiday range if public holidays must be skipped too.

How do I create a sequence of dates by month?
Use EDATE with the previous date and a month interval of 1, then fill the formula down. It advances by calendar months, so dates at the end of a long month may land on the last valid day of a shorter month.

Can I create dates across columns instead of down rows?
Yes. Enter two example dates in adjacent columns, select them, and drag the fill handle to the right. With SEQUENCE, set the row count to 1 and the column count to the number of dates you need; its first argument controls rows and its second controls columns.

Why does my date sequence start one day later than expected?
Check whether the first cell is included in the selection or output range. A sequence of ten dates starting on the date in A2 includes A2 as date one; it does not mean ten additional days after A2.

Will the sequence update if I change the starting date?
A formula-based list linked to the starting-date cell can update when that cell changes. Dates filled as fixed values will not automatically recalculate. Use formulas for a list that should follow a changing start date, and paste values only when you want to make the results static.

Can I use these methods in Excel for Mac or the web?
The fill handle and basic formulas are available in current Excel for Mac and Excel for the web. The Series dialog and some Auto Fill choices may vary by version or interface. If a menu option is missing, use two example dates and drag the fill handle.

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.