Excel Formula to Add Dates in a Weekly Sequence Automatically

Formulas & functions · Updated November 19, 2026

To add dates in weekly sequence in Excel, enter a starting date in A2, then put =A2+7 in A3 and fill the formula down. Each result is exactly seven days after the date above it, so the series stays on the same day of the week.

How the weekly date formula works

Excel stores dates as serial numbers, with each whole-number step representing one day. Adding 7 to a valid date therefore moves it forward by seven days. The result is another date value, not merely text that looks like a date, so you can sort it, use it in calculations, or compare it with other dates.

With the starting date in A2 and the first calculated date in A3, enter =A2+7 in A3. For example, if A2 contains March 4, 2025, A3 returns March 11, 2025. The next row returns March 18, then March 25. Because March 4, 2025 is a Tuesday, every result is also a Tuesday.

This method is useful for recurring appointments, weekly reporting periods, class schedules, maintenance plans, and any list that advances by seven calendar days. It does not calculate the next workday or the next instance of a different weekday; it simply adds seven days to the previous date.

Set up the dates and fill the formula down

Start by entering a real date in a cell, such as A2. You can type a date in a familiar format, but the way Excel interprets it depends partly on your computer’s regional settings. If you enter a value and it stays left-aligned or does not behave like a date in calculations, Excel may have stored it as text. Choose a recognizable date format for your region or use the date picker if it is available in your workflow.

With the start date in A2 and the next date in A3, enter =A2+7 in A3. Press Enter, select A3, and drag the small square at the lower-right corner of the selection, called the fill handle, down as far as the schedule needs to go. Excel adjusts the relative reference for each row: A4 refers to A3, A5 refers to A4, and so on.

Another option is to copy A3 and paste it into the cells below. You can also select A3 and the blank cells beneath it, then use Home > Fill > Down. If the formula is copied sideways instead of down, the reference may shift to another column, so check that each new formula refers to the date directly above it.

For a simple list, place a label such as Weekly date in the column heading and keep the starting date at the top of the list. If you want to preserve that original date, do not overwrite it with the first calculated result. Keeping the input date separate from the formula-generated dates also makes it easier to change the schedule later.

Create a whole series with one formula

In Microsoft 365 and Excel 2021, the SEQUENCE function can return multiple weekly dates from a single formula. This is convenient when you know how many entries you need and want Excel to populate the dates in one step. The results spill into cells below the formula automatically.

With the starting date in A2 and room for ten results beneath the formula, enter =A2+7*(SEQUENCE(10)-1) in B2. If A2 contains March 4, 2025, the spilled list begins with March 4, followed by March 11 and March 18, and continues through May 6, 2025. There are ten dates because SEQUENCE(10) generates ten positions, and subtracting 1 makes the first position add zero days to the starting date.

The cells where the results need to spill must be empty. If another value blocks the range, Excel displays a spill error instead of filling the list. Clear the obstructing cells or move the formula. To make a different number of dates, replace 10 with the required count. This formula is useful for a fixed-length schedule; the fill-down approach is usually easier when the list will grow or when you want to inspect each row’s formula.

Choose the right starting weekday

Adding seven days preserves the weekday of the starting date. If the start is a Friday, every result is a Friday; if the start is a Monday, every result is a Monday. The formula does not automatically move an arbitrary starting date to Monday or to another chosen weekday. Enter the first date you actually want in the series, then add seven days from there.

For example, if a reporting schedule should begin on Monday, first identify the Monday that starts the first reporting week and use that date as the initial value. Then fill the weekly formula down. This is different from asking Excel to calculate calendar week numbers: week numbering can depend on the chosen convention and the first day of the week, while adding seven days simply produces a sequence of dates.

A weekly date series also differs from a monthly recurrence. Adding seven days does not mean the same date number in each month; some months have four occurrences of a weekday and some have five, and a seven-day step can cross a month boundary. If the requirement is the first Monday of every month or the same day of each month, a weekly increment is the wrong rule. Define the intended recurrence before choosing the formula.

Format the results as readable dates

A correct formula can appear as a number because Excel stores dates numerically. That does not necessarily mean the calculation failed. Select the result cells and choose a date format from Home > Number, or open Format Cells with Ctrl+1 on Windows. On Excel for Mac, Command+1 opens Format Cells. Select a date format that makes the schedule clear, such as a short date or a format that includes the weekday.

Formatting changes how a value is displayed; it does not change the underlying date. For instance, a date may display as 11-Mar-2025 or Tuesday, March 11, 2025, while remaining the same date value for calculations. If you need to show the weekday, choose a format that includes the day name rather than adding weekday text manually to every cell.

Excel for the web also supports date formatting and formulas, though the exact controls may be arranged differently from the Windows desktop ribbon. The basic addition formula works the same way. A spill formula using SEQUENCE requires a version that supports dynamic arrays, such as Microsoft 365 or Excel 2021.

Common problems and quick checks

  • The result is a number: Apply a date number format. Excel may be showing the date’s serial value rather than a calendar-style display.
  • The date does not change when copied: Check that the formula refers to the cell above it. A copied formula with an absolute reference, such as a reference containing dollar signs, may keep pointing to the same starting date.
  • The cells display the formula itself: The cell may be formatted as Text, or Show Formulas may be enabled. Change the cell format to General or Date, then re-enter the formula. Check the Formulas tab if the worksheet is displaying formulas instead of calculated results.
  • The date appears left-aligned or does not calculate: The starting value may be text rather than a real Excel date. Re-enter it in a format recognized by your regional settings, then check whether adding seven produces a date.
  • The formula shows an error in the SEQUENCE version: Confirm that the Excel version supports SEQUENCE and that the cells below the formula are empty. Older Excel releases may not recognize the function.

If a starting value includes both a date and a time, adding seven days preserves the time portion as well. If you only want dates, use a date-only starting value or adjust the display format; hiding the time does not remove it from the underlying value. This matters when comparing schedule dates with timestamps in other columns.

Weekly formulas compared with other approaches

The simplest choice is a formula in each row: it is transparent, easy to extend, and works in older Excel versions. A single SEQUENCE formula is compact and produces a fixed number of dates, but it needs dynamic-array support and empty cells for the results. Choose based on how the list will be maintained, not just on which formula is shorter.

You can also enter two dates seven days apart, select both, and drag the fill handle to continue a pattern. This can be handy for a quick one-off list, but formulas are easier to audit and update when the start date changes. Manually typing every date is more prone to skipped or duplicated weeks, especially in a long schedule.

For a weekly plan that must skip weekends, adding seven days is still appropriate if each occurrence is on the same weekday. For a process that advances by a fixed number of working days instead, the requirement is different: weekends and possibly holidays need to be considered. Do not treat “weekly” and “seven workdays” as interchangeable descriptions.

Frequently Asked Questions

What is the simplest Excel formula to add seven days?
With a date in A2 and the next date in A3, enter =A2+7 in A3. Fill the formula down to continue the sequence.

How do I make Excel show every Monday?
Enter a Monday as the starting date, then add seven days in each following row. The weekly addition keeps every result on Monday; it does not convert a different starting weekday into Monday automatically.

Can I generate weekly dates without dragging the formula?
Yes. In Microsoft 365 or Excel 2021, use =A2+7*(SEQUENCE(10)-1) with the starting date in A2 to spill ten dates beginning with that date. Leave the destination cells empty.

Why does my weekly date formula show a number?
Excel may be displaying the underlying date serial number. Format the cell as a date using Home > Number or Format Cells; the formula can still be correct.

Does adding seven days skip weekends?
No. It adds seven calendar days, including Saturdays and Sundays. Because the interval is exactly one week, the result remains on the same weekday as the starting date.

Will the weekly sequence continue into a new year?
Yes. Excel date arithmetic handles month and year boundaries automatically. A date near the end of December will advance into January when seven days later falls in the next year.

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.