Dates and reporting
WORKDAY function: calculate a deadline N business days ahead
Step forward a given number of working days from a start date, skipping weekends and listed closures—such as a task opened Friday when Monday is a holiday.
A Friday service ticket with a Monday closure
Suppose a repair ticket opens on Friday 6 March 2026 (serial 46087 in B2) with a 1-business-day turnaround (C2 = 1), and the shop is closed on Monday 9 March 2026 (serial 46090 in D2). While NETWORKDAYS counts days between two known dates, WORKDAY calculates the target due date.
| Opened (B2) | Workdays (C2) | Closure (D2) | Due date |
|---|---|---|---|
| Fri 6 Mar 2026 (46087) | 1 | Mon 9 Mar 2026 (46090) | Tue 10 Mar 2026 (46091) |
Skip both the weekend and the Monday holiday
Without the closure argument, =WORKDAY(B2, 1) steps over Saturday (46088) and Sunday (46089) to return Monday 9 March 2026 (46090). Including D2 skips Monday as well and returns Tuesday 10 March 2026 (46091).
=WORKDAY(B2,C2,D2)Zero offsets and weekend start dates
WORKDAY counts business days after the start date: =WORKDAY(B2, 0) returns the start date itself (46087). If an online order arrives on Saturday 7 March (46088), =WORKDAY(46088, 1) lands on Monday 9 March (46090)—Saturday is not counted as the first working day.
Try the example
Use the original values or change them to test your understanding.