Work with the example
What date is three office days after the supplied Friday start? B5 is 2026-10-16, B6 is 3 and D5 is the fictional closure October 20. The calculation skips Saturday/Sunday and that closure; it does not agree or schedule an actual commitment.
| Step | Valid counted day |
|---|---|
| 1 | October 19 |
| 2 | October 21 |
| 3 | October 22 |
Edit the working cells
F5 checks all required inputs are numeric and B6 equals INT(B6), then uses WORKDAY(B5;B6;D5:D5). Change B6 to 1: October 19. Fresh 0 keeps October 16; -1 gives October 15. A Saturday October 17 start with offset 1 reaches October 19. Fraction 1.5 gives Whole days required; missing required closure gives Check inputs.
Check the failure case
F6 simply adds 3 calendar days and reaches October 19. That is the wrong operation for the stated office-day offset. This task returns a shifted date; it does not count inclusive days in an interval.
With offset 0 and the Friday start, should the start day advance?
Show the worked answer
No. The verified exercise returns October 16 unchanged.