Excel Formula to Add Dates in Sequence

Formulas & functions · Updated November 19, 2026

To add dates in sequence in Excel, enter a starting date in A2, then enter =A2+1 in A3 and fill the formula down. Each row will show the next calendar day, including weekends; use a different increment or a workday function if you need another kind of sequence.

How the basic date sequence works

Excel stores recognized dates as serial numbers, so adding 1 to a date advances it by one day. For example, if A2 contains January 1, 2026, the formula in A3 returns January 2, 2026. Fill the formula down and each row refers to the date immediately above it.

Set up the first two cells like this:

  • Enter a real Excel date in A2, such as January 1, 2026.
  • With the starting date in A2, enter =A2+1 in A3.
  • Select A3 and drag its fill handle down, or copy A3 and paste into the cells below.

Excel adjusts the relative reference as the formula is filled: the next row refers to A3, then A4, and so on. If you want to fill a selected range downward using the ribbon, select the range with the formula at its top and choose Home > Fill > Down. On Windows, Ctrl+D also fills down; on Mac, Control+D is the usual Fill Down shortcut.

Choose the interval you need

The number added determines the gap between dates. For a sequence every two days, put the starting date in A2 and enter =A2+2 in A3, then fill down. The resulting dates skip one calendar day between entries. Similarly, an increment of 7 creates a sequence one week apart.

You can also keep the interval in a separate cell so it is easy to change. With the starting date in A2 and the number of days to add in B1, enter =A2+$B$1 in A3 and fill down. If B1 contains 7, each row advances by seven days. The dollar signs make B1 an absolute reference, so it does not shift to B2 or B3 as you copy the formula.

These additions count calendar days, not business days. For instance, adding 7 to a Monday produces the following Monday. Adding 1 to a Friday produces Saturday. Use the workday option below if weekends should be excluded.

Create a sequence with a formula in every row

A formula filled down is often the clearest approach because each result depends on the prior date. In Microsoft 365 or Excel 2021, the SEQUENCE function can instead return many dates from one formula. With a start date in A2, enter =SEQUENCE(10,1,A2,1) in an empty cell. It spills a vertical list of 10 dates, starting with A2 and adding one day each time.

The arguments specify the number of rows, number of columns, starting value, and step. In that example, there are 10 rows, one column, and a step of 1. To generate 12 weekly dates from the same starting date, use =SEQUENCE(12,1,A2,7). Leave enough empty cells below the formula for the results to spill; otherwise Excel may show a #SPILL! error. SEQUENCE is available in Microsoft 365 and Excel 2021, but not in older perpetual editions such as Excel 2019.

Make a list of weekdays or workdays

If you want Monday through Friday dates and need to skip Saturday and Sunday, use WORKDAY. With the first date in A2, enter =WORKDAY(A2,1) in A3 and fill down. If A2 is Friday, the next result is Monday, assuming there is no holiday adjustment. WORKDAY treats its starting date as day zero and counts forward by the requested number of working days.

To exclude holidays too, list holiday dates in D2:D10. With the starting date in A2 and holiday dates in D2:D10, enter =WORKDAY(A2,1,$D$2:$D$10) in A3 and fill down. Make sure the holiday entries are actual Excel dates, not text that merely looks like dates. The dollar signs keep the holiday range fixed when the formula is copied.

WORKDAY uses a standard Saturday-and-Sunday weekend. If your working week has different weekend days, Excel also provides WORKDAY.INTL, which lets you specify a weekend pattern. Check its weekend argument carefully, especially when setting up a less common work schedule.

Build weekly, monthly, and quarterly dates

For a weekly sequence, adding seven days is straightforward. With the starting date in A2, enter =A2+7 in A3 and fill down. If you need the same weekday each week, this preserves it. A monthly sequence is different: a month is not a fixed number of days, so adding 30 can gradually shift the day of the month.

Use EDATE to move by calendar months. With the first date in A2, enter =EDATE(A2,1) in A3 and fill down for monthly steps. For a quarterly sequence, use =EDATE(A2,3) in A3 instead. EDATE keeps the day number where that date exists in the target month; when it does not, Excel returns the last valid day of that month.

That behavior matters for dates near month-end. Starting with January 31, a one-month EDATE step returns the last day of February. If you then fill down by referring to the previous result, the next result is based on that February date, so it may be March 28 or 29 rather than March 31. If every result must be the last day of a month, use EOMONTH instead. With the initial date in A2, enter =EOMONTH(A2,1) in A3 and fill down. The result is the last calendar day of each successive month.

Enter and display dates correctly

A date sequence works reliably only if Excel recognizes the starting value as a date. Enter a date in a format Excel understands for your regional settings, or construct one with the DATE function. With a target cell selected and no existing date to reference, enter =DATE(2026,1,1) to create January 1, 2026. DATE uses year, month, and day arguments, avoiding ambiguity between formats such as 1/2/2026.

Excel may display a valid date as a number if the cell is formatted as General or Number. That does not necessarily mean the formula is wrong: the underlying value may still be a date serial. Select the cells and choose a date format from Home > Number. Formatting changes how the value appears, not the value used in calculations. Avoid wrapping dates in TEXT just to make them look like dates if you plan to calculate with them, because TEXT returns text rather than a date value.

Common problems and how to fix them

  • The same date repeats: Check that the formula references the previous row, rather than using an absolute reference such as $A$2. A fixed reference adds the same starting date each time instead of continuing the sequence.
  • The result is a number: Apply a date number format. Excel stores dates numerically, and formatting controls their display.
  • You see #VALUE!: The starting value may be text rather than a recognized date. Re-enter it in a regional date format Excel recognizes, or build it with DATE.
  • Dates advance by the wrong amount: Check the increment. Adding 1 counts one calendar day; adding 7 counts seven calendar days. Use WORKDAY when weekends should not count.
  • Month-end dates drift: EDATE chained from a date such as January 31 can return a later date based on February’s shorter length. Use EOMONTH when every result must be a month-end.
  • A dynamic array will not appear: Clear cells in the intended spill range and check for merged cells or other obstructions. A SEQUENCE formula needs room to return its results.

Frequently Asked Questions

What is the simplest Excel formula to add one day?
With a date in A2, enter =A2+1 in A3. Fill down to continue the daily sequence.

How do I add seven days to a date in Excel?
With the starting date in A2, enter =A2+7 in A3. Copy or fill it down for dates one week apart.

How do I add dates without weekends?
With a date in A2, enter =WORKDAY(A2,1) in A3. This advances to the next weekday, skipping Saturday and Sunday; include a holiday range if those dates should also be skipped.

How do I add one month to a date?
With the original date in A2, enter =EDATE(A2,1) in another cell. EDATE advances by one calendar month and adjusts to the last valid day when the target month is shorter.

Why does Excel show a number instead of a date?
The cell may be formatted as General or Number. Apply a date format from Home > Number; the stored date value can be correct even when it appears as a serial number.

Which method should you use?

For a simple daily list, use =A2+1 and fill down. Use addition with another interval for fixed calendar-day gaps, WORKDAY for standard workdays, EDATE for month-based schedules, and EOMONTH for month-end dates. SEQUENCE is convenient when you want a complete dynamic list from one formula and have a compatible Excel version. Whichever method you choose, keep the results as real date values and apply formatting separately so the sequence remains useful for sorting, filtering, and date calculations.

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.