Move a date by whole weeks

Turn November 4, 2026 plus 2 weeks into November 18, 2026.

What you'll make

In Excel: November 4, 2026 + 2 weeks becomes November 18, 2026.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The real date.November 4, 2026
2+Adds the days to the date.November 4, 2026 + …
37*Seven days for each week.November 4, 2026 + 7 × …
4B8The number of weeks. A minus number goes back.November 18, 2026

Read it left to right. Excel works out 7 × weeks first, then adds it to the date.

=A8+7*B8

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own dates. Paste real dates and numbers of weeks into the green columns of the Template tab. The new dates fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Use whole weeks. Type a minus sign, like -2, to go back in time.

Microsoft's help: DATE function