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.

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.

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



