An equipment request arrives Friday, November 6, 2026. It is due three workdays later. Monday, November 9 is a fictional office closure.

Include the closure range

Put =DATE(2026,11,6) in B2 and =DATE(2026,11,9) in E2. Use =WORKDAY(B2,3,$E$2:$E$2) in C2 and format as a date. Count Tuesday, Wednesday, and Thursday. The expected deadline is November 12.

The weekend and Monday closure are skipped, so Tuesday is the first day counted.

Illustrated calendar. Use an actual date in the closure range.

Try the formula without the closure

Use =WORKDAY(B2,3) in another cell. It should return November 11. This check uses the standard Saturday and Sunday weekend and counts workdays after the start. Extend the closure range as needed, and confirm those assumptions match your turnaround rule.

The same start and day count return November 11 without the closure and November 12 with it.

Illustrated control formula. Check how your team counts the start day.

Microsoft’s WORKDAY function reference