How to Add Weekly Dates in Excel

How-to basics · Updated November 20, 2026

To add weekly dates in Excel, enter your starting date in A2, then enter =A2+7 in A3 and fill the formula down. Each result will be seven days after the date above it. Before entering the formula, make sure A2 contains a real Excel date, not text. You can also use Excel’s Series command or the fill handle if you prefer not to copy a formula.

What You’ll Need

  • A Microsoft Excel workbook in Excel for Microsoft 365 on Windows.
  • A starting date and, if you are planning a schedule, an idea of how many weekly dates you need.
  • A blank column or row where you can place the dates. The examples below use column A.

No add-ins or special settings are required. The same basic formula works in Excel for Mac and Excel for the web, although some ribbon locations and keyboard shortcuts may differ slightly.

Step-by-Step

  1. Enter the first date. Click cell A2 and type the date you want to start from, such as 1/5/2026. Press Enter. Excel usually recognizes a date when you enter it in a format supported by your regional settings. If it displays as a number, that can still be a valid date: Excel stores dates as serial numbers and applies a date format to show them as calendar dates.
  2. Check that Excel recognized it as a date. Select A2 and look at the formula bar. A date should appear as a date value, and changing the cell to a date format should display it as a date. If Excel treats the entry as text, the weekly calculation may not work. Avoid starting with an apostrophe, such as ‘1/5/2026, because that deliberately stores the entry as text.
  3. Enter the weekly formula in the next cell. With the starting date in A2 and the next date expected in A3, type =A2+7 in A3 and press Enter. Excel adds seven days to the date in A2. For example, if A2 is January 5, 2026, A3 should display January 12, 2026. The arithmetic is seven calendar days, so the weekday stays the same.
  4. Copy the formula down the column. Select A3 and point to the small square at the lower-right corner of the selection, called the fill handle. When the pointer changes to a small plus sign, drag it down through the cells you need. Excel adjusts the relative reference for each row: A4 refers to A3, A5 refers to A4, and so on. If you need a fixed number of dates, count the starting date as one of them. For example, a list of 12 weekly dates includes the start date plus 11 later dates.
  5. Check the final date and the interval. Compare a few consecutive entries. Each should be exactly seven days later than the one above it. If the first date is January 5, 2026, the next dates should be January 12, January 19, and January 26. Checking the first few rows catches an incorrect starting value or a formula that was copied with the wrong interval before you use the list elsewhere.
  6. Format the dates if needed. Select the completed range, then choose Home > Number Format and select a date style. For a custom appearance, open the Format Cells dialog with Ctrl+1 on Windows, select the Number tab, and choose Date or Custom. For example, a format such as ddd, mmm d displays a weekday and abbreviated month. Formatting changes how the dates look, not the underlying seven-day spacing.
  7. Use the Series command as an alternative. If you want Excel to generate the dates without leaving a formula in every cell, enter the start date in A2 and select the cells to fill, such as A2:A13. Choose Home > Fill > Series. In the dialog, choose Columns, select Date as the Type, choose Day as the Date unit, and enter 7 for Step value. If you want to stop at a particular date, enter it as the Stop value. Select OK. Excel fills the selected cells with dates seven days apart.

The formula method is usually easiest when the dates need to update automatically after you change the starting date. The Series method is useful when you want fixed date values or a quick sequence across a known range. In the Series dialog, selection size matters: if you select A2:A13, Excel fills only that range, even if the stop date would allow more entries.

Common Mistakes

  • Using the wrong increment. Adding 1 creates daily dates, while adding 7 creates weekly dates. If your schedule is intended to repeat on the same weekday, check that the formula adds seven rather than one.
  • Dragging a single date and expecting weekly steps. Excel may extend one date as consecutive days when you drag its fill handle. To make the pattern clear, enter two dates exactly one week apart, select both, and drag the handle; or use the formula or Series command above.
  • Entering dates as text. A date that Excel cannot interpret may not calculate as expected. Check the cell alignment and formula behavior, and try entering the date in a format accepted by your computer’s regional settings. Do not rely on changing the display format alone to convert text into a date.
  • Counting the start date incorrectly. If you need 10 weekly dates including the first one, you need nine weekly additions after the start date. If you instead need 10 future dates after the start date, your list will contain 11 dates total.
  • Overwriting the starting date or formula. When using the fill handle, make sure you drag from the formula cell and not from the starting-date cell. After filling, click a later result and confirm that its formula refers to the cell directly above it.
  • Confusing display with stored values. A date formatted to show only a month and year may hide the day, even though the underlying dates still differ by seven days. Use a format that includes the day while checking your sequence.

Tips

  • Put a label above the list. Add a heading such as Week starting in A1 so other people know what each date represents. If each date marks the beginning of a work or reporting week, make that clear in the label.
  • Use a two-date pattern when dragging. Enter the start date in A2 and the date seven days later in A3, select both cells, and drag the fill handle. Excel can extend the visible interval. This is convenient for a short list, but check the first few results rather than assuming the pattern was detected correctly.
  • Keep the date range reusable. With the formula method, changing A2 recalculates the dates below it. This is handy for a new project or reporting period. If you need to preserve the original dates, copy the range and use Paste Special > Values to replace formulas with their current results.
  • Use a separate column for notes. Put a task, owner, or status beside each date rather than combining it with the date in one cell. Keeping dates as date values makes sorting, filtering, and later calculations more dependable.
  • Choose the method for the job. Use a formula for a list that should recalculate, the fill handle for a quick pattern, or Series for a specified range and step. The methods produce a similar-looking list, but formulas remain linked to the starting date while Series results are entered as values.

For keyboard filling, enter the formula in A3, select A3 through the last cell you want to fill, and press Ctrl+D on Windows. In Excel for Mac, Command+D is the usual Fill Down shortcut. The first selected cell should contain the formula to copy; this shortcut does not infer a weekly pattern from a lone date. In Excel for the web, the fill handle is a straightforward alternative if a desktop shortcut behaves differently in your browser.

Troubleshooting

  • The result shows a number instead of a date: The calculation may be correct, but the cell is formatted as General or Number. Select the result cells and choose a date format from Home > Number Format. Excel stores dates as serial numbers, so applying a date format often makes the intended result visible.
  • The formula returns an error: Check that the starting cell contains a valid date and that the formula begins with an equals sign. In the example layout, A2 contains the date and A3 contains =A2+7. If A2 contains text, replace it with a date Excel recognizes, then re-enter or recalculate the formula.
  • Dates increase by one day instead of a week: Inspect the formula bar for the filled cells. A formula such as =A2+1 adds one day. Replace the first formula with the seven-day version, then fill it down again.
  • The fill handle is not visible: Select the cell and look for the small square at its lower-right corner. If it is unavailable, use the Series command instead, or check Excel’s options for the fill handle setting. In desktop Excel for Windows, open File > Options > Advanced and look under Editing options for Enable fill handle and cell drag-and-drop.
  • The dates look right but use the wrong weekday: The formula preserves the weekday of the starting date. If you need Mondays, first make sure the start date is a Monday; adding seven will not shift a Wednesday start to Monday. Correct the starting date, then let the sequence recalculate.
  • The Series command fills too few or too many cells: Check the range you selected before opening Home > Fill > Series. Excel fills the selected range, so select enough cells for the number of dates you need. For an endpoint-based series, verify the Stop value and that the step is 7 days.

Frequently Asked Questions

How do I create weekly dates without dragging?
Enter the start date, select the range to fill, and use Home > Fill > Series. Choose Columns, Date, Day, and a Step value of 7. You can also copy a formula down with Ctrl+D on Windows after placing it in the first cell below the start date.

Can I add weekly dates horizontally across a row?
Yes. Put the starting date in A2, enter a formula in B2 that adds seven to A2, then fill right. In the Series dialog, choose Rows rather than Columns. Check that each date is one week after the cell to its left.

How can I make the dates weekly but stop at a certain date?
Use Home > Fill > Series, set the Date unit to Day and Step value to 7, and enter your desired endpoint as the Stop value. Alternatively, fill a formula down only as far as needed and remove any dates beyond your endpoint.

Can I make the list show only weekdays?
Adding seven days keeps each date on the same weekday; it does not skip weekends within a week. If you want one date per working week, starting with a Monday and adding seven is usually appropriate. If you mean dates that move forward by five working days, that is a different pattern and needs a workday-based calculation.

Will the dates update if I change the first date?
Yes, if you used formulas such as the one in the example. Changing A2 updates the dates that refer to it through the chain below. Dates created with the Series command are fixed values and will not recalculate when you edit the original start date.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.