To add weeks to a date in Excel, multiply the number of weeks by 7 and add the result to the date: if the date is in A2 and the number of weeks is in B2, enter =A2+B2*7. Format the result cell as a date if Excel displays a number instead.
The basic formula for adding weeks
Excel stores dates as serial numbers, so date arithmetic works by adding or subtracting days. A week has seven calendar days; multiplying a week count by 7 converts it to a number of days. The formula then adds those days to the starting date.
With a starting date in A2 and a whole number of weeks in B2, enter =A2+B2*7 in C2. For example, if A2 contains January 10, 2025, and B2 contains 3, the result is January 31, 2025. Three weeks is 21 days, and January 10 plus 21 days is January 31.
The formula uses cell references rather than hard-coded values, so you can change the date or week count and the result updates. Excel follows normal arithmetic precedence: multiplication happens before addition, so the week count is multiplied by 7 before those days are added to the date.
Why adding weeks works in Excel
A date that looks like “January 10, 2025” is generally a formatted number underneath. Excel can add a number of days to that serial value and display the resulting date. This is why the formula does not need a special “add weeks” function.
That distinction also explains a common surprise: a correct formula may initially show a value such as 45687 instead of a calendar date. The calculation can still be right; the result cell may simply be formatted as General or Number. Apply a date format to display it in a familiar way.
Adding seven days preserves the date’s position within the week. If the starting date is a Monday, adding one week gives the following Monday. It does not mean “move to the next week number” under every calendar convention, nor does it skip weekends or holidays.
Set up the cells and enter the formula
For a simple schedule, use one column for the starting date, one for the number of weeks, and one for the calculated date. In Excel for Microsoft 365 on Windows, the steps are:
- Enter a valid date in A2, such as 1/10/2025. Excel interprets date entry according to your regional settings.
- Enter a number of weeks in B2, such as 3. Use a whole number when you mean complete weeks.
- Select C2, type the formula using the A2 and B2 layout, then press Enter.
- If C2 shows a serial number, select it and choose Home > Number > Number Format > Short Date. You can choose another date style from the same format list.
On Windows, Ctrl+1 opens Format Cells, where you can select a date format. On Mac, Command+1 opens Format Cells. The ribbon wording and layout can vary slightly by Excel release, but the same calculation works in desktop Excel for Windows and Mac. Excel for the web also supports the formula and date formatting.
For a column of records, place the formula in the first result row and copy it down. Excel adjusts relative references as the formula moves: the next row will refer to A3 and B3, then A4 and B4, and so on. Check that the starting dates are genuine Excel dates rather than text that only looks like dates.
Examples with different dates and week counts
Suppose you are planning a follow-up six weeks after February 5, 2024. With the starting date in A2 and the number 6 in B2, the formula returns March 18, 2024. Six weeks equals 42 days; because 2024 is a leap year, February has 29 days, and February 5 plus 42 days is March 18.
For a fixed interval that will not change, you can put the week count directly into the calculation. With the starting date in A2, enter =A2+3*7 to add exactly three weeks. The result is easier to update when the week count is in its own cell, however, and a separate input makes the worksheet more transparent to other people.
You can also add weeks to a date in the formula itself. With the year, month, and day supplied to the DATE function, =DATE(2025,1,10)+3*7 returns January 31, 2025. This approach is useful for a one-off calculation or a worksheet template, but a date entered in a cell is usually more convenient when the starting point changes.
Negative week counts work as subtraction: a value of -2 in B2 moves the result 14 days before the date in A2. This can help calculate a lead-in date before an event. If negative values are not meaningful for your schedule, prevent them through input checks or explain the intended range beside the input cells.
Use cell references, fill formulas, and handle blanks
Keeping the date and week count in separate cells makes a schedule easier to maintain. Label the columns clearly—for example, “Start date,” “Weeks after start,” and “Due date”—and keep the same data type in each column. A text entry such as “three weeks” is not the same as the numeric value 3 and will not behave as expected in the calculation.
If you copy the basic formula into many rows, blank inputs can produce confusing results. A blank date may be treated like zero, which can lead to an old-looking date after the week calculation. To keep the output empty until both inputs are filled, with the starting date in A2 and the week count in B2, use =IF(OR(A2="",B2=""),"",A2+B2*7). This returns a blank if either input is blank; otherwise it calculates the date.
For a more controlled worksheet, use Data Validation to restrict the week-count cells to whole numbers or to a chosen range. On Windows, select the input cells and choose Data > Data Validation. A whole-number rule can reduce accidental entries such as a word, an unintended decimal, or a week count outside the range you expect. The feature is also available in Excel for Mac, although its dialog placement may differ.
When filling a formula down, inspect a few rows to confirm that references point to the corresponding inputs. If every row should use one fixed week-count cell, make that reference absolute with dollar signs. For example, with dates in A2:A20 and a single week count in B1, use =A2+$B$1*7 in C2 and copy it down. The date reference changes by row, while the reference to B1 stays fixed.
Calendar weeks versus workweeks
The basic calculation adds calendar weeks. Three weeks always means 21 days, including Saturdays, Sundays, and holidays. That is appropriate for many tasks such as setting a reminder, tracking a subscription period, or estimating a date a fixed number of weeks after another date.
Business schedules often use a different rule. If “three weeks” means 15 working days, adding 21 calendar days will not necessarily give the intended result. Weekends and holidays may need to be excluded, and the correct method depends on whether the starting day counts and which holidays your organization observes.
Excel provides WORKDAY for adding working days, but it takes a number of workdays rather than a number of weeks. With a starting date in A2, the number of weeks in B2, and an optional holiday list in H2:H20, use =WORKDAY(A2,B2*5,H2:H20) if your business rule defines each week as five working days. For three weeks, this adds 15 working days and skips Saturdays, Sundays, and the listed holidays. Confirm that this is the rule you actually need: it is not the same as adding three calendar weeks.
A separate question is whether a date should land on a particular weekday or at the end of a reporting week. Those are calendar rules, not simple week addition. First determine the intended convention—for example, Sunday-to-Saturday or Monday-to-Sunday—and then calculate or look up the target according to that convention. Do not assume that adding seven days automatically finds a week’s closing date.
Common problems and how to fix them
- The result is a number. Apply Short Date or another date format to the result cell. Formatting changes how the value appears, not the underlying calculation.
- The formula returns an error or an unexpected result. Check that the starting value is a real date and the week count is numeric. A date imported as text may need to be converted before date arithmetic works reliably.
- The date is interpreted as the wrong month or day. Entries such as 3/4/2025 can mean March 4 or April 3 depending on regional settings. Use an unambiguous date entry, such as a date selected through the calendar interface where available, or verify the resulting date after entry.
- The formula seems one day off. Confirm whether your intended interval includes the starting date. Adding one week means the same weekday seven days later; it does not count the starting date as day one of a seven-date inclusive range.
- The displayed date includes a time. A fractional week count can add part of a day, because Excel dates can contain time fractions. Use whole-week inputs when that is what the schedule requires, or choose a format that shows time if a partial day is intentional.
- The result differs across workbooks or computers. Excel workbooks can use different date systems, and imported or copied data can also carry formatting or text issues. If a date appears far in the past or future, inspect the source values and workbook settings before relying on the result.
Also remember that changing a cell’s date format cannot repair an invalid date or turn arbitrary text into a valid date automatically. When data comes from another system, verify a few imported rows and use Excel’s conversion tools or a deliberate cleanup step if necessary.
Choose the right approach for your schedule
Use the simple date-plus-seven-times-weeks calculation when the requirement is a fixed number of calendar weeks. It is compact, easy to audit, and works in older as well as current Excel versions. A separate week-count cell is best when users may change the interval; a fixed number in the formula can be suitable for a small, unchanging calculation.
Choose a working-day calculation instead when weekends or holidays must be skipped. For a rule based on calendar months, do not treat a month as four weeks: months have different lengths, so adding four weeks is not equivalent to moving one month forward. Excel’s EDATE function is intended for moving a date by a number of months, while adding weeks remains a day-based calculation.
For a date that should update automatically relative to today, Excel’s TODAY function can serve as the starting point. With the week count in B2, =TODAY()+B2*7 returns the date that many calendar weeks from the current date. TODAY updates when the workbook recalculates, so this is useful for a rolling deadline but unsuitable when you need to preserve the exact date on which the calculation was first made. For a fixed record, enter or store the original date instead.
Frequently Asked Questions
What is the Excel formula to add one week to a date?
With the date in A2, use =A2+7. Format the result cell as a date if it displays as a number.
How do I add a number of weeks stored in another cell?
With the starting date in A2 and the number of weeks in B2, use =A2+B2*7. For example, B2 equal to 4 adds 28 calendar days.
Can I add weeks without including weekends?
Not with ordinary calendar-week addition: it includes every day. If you need working days, define the business rule and use WORKDAY with the appropriate number of days and, if needed, a holiday range.
Why does Excel show a number instead of a date?
Excel stores dates as numbers. Select the result cell and apply a date format, such as Short Date, from Home > Number > Number Format.
Does adding four weeks equal adding one month?
No. Four weeks is 28 days, but calendar months can have 28, 29, 30, or 31 days. Use a month-based calculation when the requirement is to move by calendar months.
Can the week count be negative?
Yes. A negative number subtracts that many weeks from the starting date. For instance, -1 moves the result seven calendar days earlier.
Related
- Data Validation Framework: Design, Rules, and Examples
- What Is Power Query? Excel Data Cleanup Explained
- AI and Power Query: What It Can and Cannot Do in Excel
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Sum Highlighted Cells: Quick Methods and FormulasTo add numbers in cells you have selected, select them and read Sum on Excel’s status bar; to…
- COUNTIF Excel Not Equal: Formulas, Blanks, and ExamplesTo count cells that are not equal to a value in Excel, use =COUNTIF(A2:A20,"<>Apple"). The <> operator means…
- COUNTIF in Excel: Count Values Less Than a Set NumberTo count values below a number in Excel, use =COUNTIF(A2:A20,"<10"). Replace A2:A20 with your range and 10 with…
- Excel Rank Formula Without Duplicate Ranks: ExamplesTo give tied values different, consecutive ranks in Excel, enter =RANK.EQ(B2,$B$2:$B$10,0)+COUNTIF($B$2:B2,B2)-1 beside the first value and fill down.…
- Excel Budgeting and Forecasting Functions: A Practical GuideExcel budgeting and forecasting functions help you total planned and actual spending, compare results with a budget, and…
- Excel Data Validation List Formula: Examples and FixesFor an Excel drop-down list, select the cells, choose Data > Data Validation, set Allow to List, and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.