How do I use WORKDAY.INTL in Excel?
Use WORKDAY.INTL when you want to calculate a due date with custom weekend rules. Enter Start date, Number of days, Weekend pattern in that order, then add optional arguments when needed.
Excel Function
WORKDAY.INTL
Returns workday-based date with customizable weekends.
WORKDAY.INTL(start_date, days, [weekend], [holidays])Arguments
start_date
RequiredEnter a date/reference-related value.
days
RequiredEnter a numeric value.
weekend
OptionalSet weekend pattern with codes 1-7 / 11-17, or a 7-character string such as "0000011".
holidays
OptionalSpecify a reference range. You can drag or click start/end cells.
Practice Preview
Use WORKDAY.INTL to return the date 5 workdays after cell B2 (Start Date in column B) using 1 (Saturday and Sunday) and Holiday in column E. You can set ranges by dragging from the start cell to the end cell in the same argument field.
Example Table
| # | ATask ID | BStart Date | CEnd Date | DNotes | EHoliday |
|---|---|---|---|---|---|
| 2 | T001 | 2026/03/01 | 2026/03/05 | Standard task | 2026/03/03 |
| 3 | T002 | 2026/03/03 | 2026/03/10 | Priority task | 2026/03/06 |
| 4 | T003 | 2026/03/05 | 2026/03/12 | Standard task | 2026/03/10 |
| 5 | T004 | 2026/03/08 | 2026/03/14 | Urgent task | 2026/03/12 |
| 6 | |||||
| 7 | |||||
| 8 |
How to Use (Formula)
=WORKDAY.INTL(B2, 5, 1, E2:E5)Result
2026/03/11
Practice This Function
WORKDAY.INTL FAQ
Where can I practice WORKDAY.INTL?
Use the "Start Function Practice" button to jump straight into WORKDAY.INTL drills.
What arguments does WORKDAY.INTL use?
The main arguments are Start date, Number of days, Weekend pattern, Holiday range. Start with the required ones, then add optional arguments if needed.