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)

Taught hands-on in Level 3: Intermediate Lookups & Data Summaries · Dates & Times module

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

=WORKDAY.INTL(start_date, days, [weekend], [holidays])

Arguments

ArgumentRequired?What it does
start_dateYesThe date to count from.
daysYesWorking days to move: positive or negative.
weekendOptional1 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).
holidaysOptionalA range of dates to skip as well.

Examples

Example 1 — Different weekends, same task

Five working days from Friday, March 13, 2026.

B2fx=WORKDAY.INTL(DATE(2026,3,13),5,1)
AB
1WeekendDue
21 (Sat–Sun)3/20/2026
37 (Fri–Sat)3/19/2026
411 (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.

C2fx=WORKDAY.INTL(A2,B2,"1010100")
ABC
1StartDaysDue
23/13/202633/17/2026
=WORKDAY.INTL(A2,B2,"1010100") Explain

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

Kyle Stott

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.