Add Sunday–Thursday workdays

Friday and Saturday off: Thursday January 15, 2026 plus 1 workday is Sunday.

What you'll make

In Excel: Thursday January 15, 2026 + 1 workday becomes Sunday January 18, 2026.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The real date to start from.November 4, 2026
2B8How many workdays to move. A minus number goes back.5
37Makes Friday and Saturday the weekend.Friday and Saturday off
4WORKDAY.INTL( … )Counts that many workdays, Sunday to Thursday.November 11, 2026

Read it left to right. The start date isn't counted, and 0 keeps it as it is.

=WORKDAY.INTL(A8,B8,7)

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 workdays 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

Holidays still count as workdays. Check any new date that lands on a holiday.

Microsoft's help: WORKDAY.INTL function