Adding weeks to a date is the friendliest arithmetic the calendar offers, because weeks are the one unit that never changes size. A week is always seven days - through February, through leap years, across every month boundary - so adding weeks is a single multiplication followed by a day count. Better still, the answer always lands on the same weekday you started from, which gives you a built-in error check. This guide covers the method, worked examples in both directions, and the few traps that catch people out.
The method: multiply by 7, then count days
Convert the weeks to days (weeks x 7), then add that many days to your date. Six weeks is 42 days. Starting from Monday, June 1, 2026: June has 30 days, so 29 days takes you to June 30, and the remaining 13 days land on Monday, July 13, 2026. Note the weekday - Monday to Monday. Adding whole weeks can never change the weekday, because 7, 14, 21 and every other multiple of 7 divide exactly into the weekly cycle. If a result you compute lands on a different weekday from the start, the count went wrong somewhere; that one check catches most slips.
For longer jumps, work in stages. Ten weeks from Monday, January 5, 2026 is 70 days: 26 days finishes January, 28 more finish February (54 total), and 16 more land on Monday, March 16, 2026. Breaking the count at month boundaries keeps the arithmetic small and checkable. The weeks between dates calculator verifies any result instantly - enter your start and your computed end date and it should report exactly the number of weeks you added.
Subtracting weeks: the same road, backwards
To subtract, multiply by 7 and count backwards. Six weeks before Monday, July 13, 2026 is 42 days earlier: 13 days back reaches June 30, and 29 more reach Monday, June 1, 2026 - the date we started from, as it must be. Backwards counts fail most often at February, because people reflexively give it 30 or 31 days. In a non-leap year February has 28 days; in a leap year, 29. A 6-week count backwards from mid-March crosses all of February, so the leap question changes the answer by a day. When the count matters, write the month lengths down rather than trusting memory - or check the span with the days between calculator, which uses the real calendar.

Adding weeks in Excel and Google Sheets
Spreadsheets store dates as day counts, so the formula is direct: =A1+7*6 adds six weeks to the date in A1. For a weeks value in B1, use =A1+7*B1, and for subtracting, =A1-7*B1. Format the result as a date; if it shows a five-digit number, the formula is right and only the formatting is missing. There is no dedicated "add weeks" function because none is needed - but resist the temptation to use EDATE or month functions for week work. Adding "3 months" and adding 12 or 13 weeks are different operations that can land a week apart, and a spreadsheet will happily do the wrong one if you pick the familiar function.
Weeks plus extra days
Real requests often mix units: "8 weeks and 3 days from now". Convert the whole thing to days - 8 x 7 + 3 = 59 - and add once. Adding the weeks first and then the days in two separate steps invites an off-by-one at the join, because people recount the landing day of the first step as day one of the second. One conversion, one addition, one answer. The same discipline applies to "in a fortnight" (14 days exactly) and to business-week requests: "6 working weeks" is not 42 calendar days but 30 working days, which usually spans about 40 to 44 calendar days once weekends and holidays are included - a different calculation that should be labeled as such.
Quick reference: adding weeks from a Monday
| Add | Days | From Mon, June 1, 2026 |
|---|---|---|
| 1 week | 7 | Monday, June 8, 2026 |
| 2 weeks | 14 | Monday, June 15, 2026 |
| 4 weeks | 28 | Monday, June 29, 2026 |
| 6 weeks | 42 | Monday, July 13, 2026 |
| 8 weeks | 56 | Monday, July 27, 2026 |
| 12 weeks | 84 | Monday, August 24, 2026 |
Every row lands on a Monday, which is the whole point: if you build the same table from your own start date and any row breaks the weekday pattern, that row contains the error.
Common traps
Counting the start day as day 1. If June 1 is "day 1", then 7 days later gets counted as June 7 - but one week after June 1 is June 8. The start date is day 0 for elapsed counting; the week completes when the same weekday returns. Month-end shortcuts. Adding a week at a time on a wall calendar is safe; jumping "about a month" for four weeks is not - four weeks is 28 days, and the error grows with every jump. Daylight saving. Adding days to a date is immune, but adding 168 hours to a date-time is not: across a clock change, 7 x 24 hours lands an hour off from 7 calendar days. Work in dates, not hours, whenever the unit is weeks. Assuming the result is a working day. Adding whole weeks preserves the weekday, so a Friday start gives a Friday result - fine - but it can still land on a public holiday, which no amount of week arithmetic will warn you about.
Adding weeks across a year boundary
Year boundaries frighten hand counters more than they should. The weekday-preservation rule does not care about December 31, so the method is identical: multiply, then walk forward through the months. Add 10 weeks to Monday, November 30, 2026: 10 x 7 = 70 days. December holds 31 of them (landing on December 31 with 39 remaining - count it carefully: November 30 plus 31 days is December 31), then January 2027 holds 31 more (8 remaining at January 31), and 8 days into February lands on Monday, February 8, 2027. The weekday check confirms the walk: the answer is a Monday, as any whole number of weeks added to a Monday must be. Leap years are equally undramatic - February simply holds 29 days instead of 28 during the walk, which is why the month-remainder step must use the actual February length for the year in question. Where the stakes are high, do the walk and then verify the result with the calculator; the two methods agreeing is the strongest quick check there is.
Frequently asked questions
How do I add weeks to a date?
Multiply the weeks by 7 to get days, then count that many days forward from the date. Six weeks is 42 days, so 6 weeks after Monday, June 1, 2026 is Monday, July 13, 2026. The weekday never changes when you add whole weeks.
How do I subtract weeks from a date?
The same method in reverse: multiply by 7 and count backwards. Six weeks before July 13, 2026 is June 1, 2026. Counting backwards across a month boundary is easier by converting to days first, exactly as when adding.
What is 12 weeks from today?
Twelve weeks is 84 days, so count 84 days forward from today's date - the result is the same weekday as today, 12 weeks later. The weeks between dates calculator can confirm the span between today and the result.
How do I add weeks to a date in Excel?
Use =A1+7*n, where A1 holds the date and n is the number of weeks. Excel stores dates as day numbers, so adding 7 per week works directly. Format the result cell as a date.
Does adding weeks ever change the weekday?
No. Whole weeks are multiples of 7 days, so the result always falls on the same weekday as the start date. If your result lands on a different weekday, a day was added or dropped somewhere in the count.
