WORKDAY.INTL function
Calculate a delivery date in working days.
Date and time
Where can you use it?
Planning and operations teams. Use this group to work with dates and times in calendars, delivery schedules, shifts and period reporting.
Scenario in the workbook
Move deadlines using an explicit weekend code. Negative offsets move backward.
A worked example from the workbook
| Row | A | B |
|---|---|---|
| 6 | Input | Comparison |
| 7 | 46023 | 1 |
| 8 | 46023 | 2 |
| 9 | 46023 | -1 |
Record 1
=WORKDAY.INTL(A7,B7,1)Expected result46024
See the inputs and instructions for all 3 examplesCopyable formulas
English Excel · en-US
=WORKDAY.INTL(DATE(2026,11,27),2,1)Turkish Excel · tr-TR
=İŞGÜNÜ.ULUSL(TARİH(2026;11;27);2;1)Example and expected result
The next two business days after Friday, November 27, are Monday and Tuesday. Weekend code 1 excludes Saturday and Sunday.
Expected result December 1, 2026.
Worked examples
Move deadlines using an explicit weekend code. Negative offsets move backward.
Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.
| Row | A | B |
|---|---|---|
| 6 | Input | Comparison |
| 7 | 46023 | 1 |
| 8 | 46023 | 2 |
| 9 | 46023 | -1 |
| Case | Formula | Expected result |
|---|---|---|
| Record 1 | =WORKDAY.INTL(A7,B7,1) |
46024 |
| Record 2 | =WORKDAY.INTL(A8,B8,1) |
46027 |
| Record 3 | =WORKDAY.INTL(A9,B9,1) |
46022 |