What it does
=WORKDAY(A2,10) returns the 10th working day after A2; the start day itself is not counted. A negative number goes back: =WORKDAY(B2,-5) is 5 working days before delivery, the latest day preparation must start.
Pass a range of holiday dates as the third argument and those days are skipped as well. The result is a date serial number; if the cell is not formatted as a date, it shows as a number.
To count the working days between two dates use NETWORKDAYS; where Saturday is a working day, use WORKDAY.INTL, which lets you choose the weekend. To add calendar months, there is EDATE.
Syntax
=WORKDAY(start_date, days, [holidays])=İŞGÜNÜ(başlangıç; gün_sayısı; [tatiller])Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
start_date | Required | The date the count starts from; this day is not counted. |
days | Required | The number of working days to add; a negative number goes back. Any decimal part is dropped. |
holidays | Optional | A range of holiday dates to skip, e.g. $F$2:$F$3. |
Examples
1Find a delivery date while skipping holidays
Each order's lead time in working days is in column C. WORKDAY skips weekends and the holidays in column F; here the company is closed on Thursday 29 October 2026.
=WORKDAY(B2,C2,$F$2:$F$3)| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Order Date | Lead Time (Working Days) | Delivery Date | Holiday | |
| 2 | SO-901 | 22-Oct-2026 | 5 | 30-Oct-2026 | 29-Oct-2026 | |
| 3 | SO-902 | 23-Oct-2026 | 3 | 28-Oct-2026 | 1-Jan-2027 | |
| 4 | SO-903 | 30-Oct-2026 | 2 | 3-Nov-2026 | ||
| 5 | SO-904 | 5-Nov-2026 | 10 | 19-Nov-2026 |
- D2 (filled down to D5)
=WORKDAY(B2,C2,$F$2:$F$3)
Adding 5 working days to the 22 October order skips the weekend and 29 October; delivery is 30-Oct-2026. For SO-903, placed on a Friday, the count starts on Monday: 3-Nov-2026.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Work back from an event to the start of preparation
A negative number of days counts backwards. Column D goes back from the event date by the preparation time in working days and finds the latest day preparation must begin.
=WORKDAY(B2,-C2)| A | B | C | D | |
|---|---|---|---|---|
| 1 | Event | Date | Preparation (Working Days) | Preparation Start |
| 2 | Trade fair stand | 16-Nov-2026 | 5 | 9-Nov-2026 |
| 3 | Dealer meeting | 30-Nov-2026 | 8 | 18-Nov-2026 |
| 4 | Year-end stock count | 31-Dec-2026 | 3 | 28-Dec-2026 |
- D2 (filled down to D4)
=WORKDAY(B2,-C2)
For the fair on 16 November, preparation must start by 9-Nov-2026; for the dealer meeting, the date is 18-Nov-2026.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- Shows a number
Cause: The result appears as a number such as 46342 because the cell is not formatted as a date.
Fix: Apply a date format to the cell.
- #VALUE!
Cause: The start date or a value in the holiday list is text that cannot be converted to a date.
Fix: Enter the dates as real dates.
Good to know
- To move a date that is not a working day to the next working day:
=WORKDAY(A2-1,1). If A2 is already a working day, it stays as it is. - Lock the holiday range like
$F$2:$F$3so it does not shift when the formula is filled down.
In Nexell
Get Nexell to do it from a sentence
Add a Delivery Date column to the order list showing 7 working days after the order date, and skip the dates in my holiday list
Convert to tableBring the order list and the holiday list into the tool and type this. Nexell adds the Delivery Date column with real Excel formulas and shows it in the preview; in the downloaded file, the delivery date changes when the order date does.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
How do I add working days to a date in Excel?
=WORKDAY(A2,10) adds 10 working days to A2, skipping weekends. To skip holidays too, list their dates in a range and pass it as the third argument.
Related functions
- NETWORKDAYSTAMİŞGÜNÜ · Working days between two dates.
- WORKDAY.INTLİŞGÜNÜ.ULUSL · Date a number of working days away with a custom weekend.
- EDATESERİTARİH · Date a number of months before or after.
- EOMONTHSERİAY · Last day of the month, months away.
- WEEKDAYHAFTANINGÜNÜ · Day of the week (1 = Sunday; type 2 makes Monday 1).