Add or subtract calendar days

Turn November 4, 2026 plus 30 days into December 4, 2026.

What you'll make

In Excel: December 31, 2026 + 1 day becomes January 1, 2027.

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 + …
3B8The number of days. A minus number goes back.December 4, 2026

Read it left to right. Weekends and holidays count as days. Zero keeps the date.

=A8+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 days 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 days. Type a minus sign, like -7, to go back in time.

Microsoft's help: DATE function