WORKDAY.INTL Function
Like WORKDAY, but you choose which days are the weekend.
Category
Date & Time
Available in
Excel 2010+, Microsoft 365
Returns
A date (serial number)
Overview
WORKDAY.INTL counts working days with a weekend you choose — Friday and Saturday, Sunday only, or any custom pattern.
Pick a weekend code, or write a 7-character mask of 0s and 1s starting on Monday, where 1 means a day off.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| start_date | Yes | The date to count from. |
| days | Yes | Working days to move: positive or negative. |
| weekend | Optional | 1 Sat–Sun (default), 2 Sun–Mon, 3 Mon–Tue, 4 Tue–Wed, 5 Wed–Thu, 6 Thu–Fri, 7 Fri–Sat, 11 Sun only, 12 Mon only … 17 Sat only — or a 7-character text mask such as "0000011" (Monday first, 1 = day off). |
| holidays | Optional | A range of dates to skip as well. |
Examples
Example 1 — Different weekends, same task
Five working days from Friday, March 13, 2026.
| A | B | |
|---|---|---|
| 1 | Weekend | Due |
| 2 | 1 (Sat–Sun) | 3/20/2026 |
| 3 | 7 (Fri–Sat) | 3/19/2026 |
| 4 | 11 (Sun only) | 3/19/2026 |
Example 2 — A custom pattern
A part-time team works Tuesday, Thursday, Saturday and Sunday: Monday, Wednesday and Friday are days off.
| A | B | C | |
|---|---|---|---|
| 1 | Start | Days | Due |
| 2 | 3/13/2026 | 3 | 3/17/2026 |
Saturday 14th, Sunday 15th and Tuesday 17th are the three working days.
Common mistakes
- #VALUE! with a text mask. The mask must be exactly 7 characters of 0 and 1, in quotes, and can't be all 1s.
Notes
- Related functions: WORKDAY, NETWORKDAYS.INTL.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.