Cellwise Start free

Dates function

Excel WORKDAY.INTL function

WORKDAY.INTL works like WORKDAY but lets you choose the weekend. Use a code for common weekends, such as 7 for Friday and Saturday or 11 for Sunday only, or a seven-character string of 0s and 1s, Monday first, for any pattern of working days.

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

Arguments

start_date
The date to count from. It is not counted itself.
days
The number of working days to move. Negative counts back.
weekend
Optional. A code (1 Sat-Sun, 2 Sun-Mon, 3 Mon-Tue, 4 Tue-Wed, 5 Wed-Thu, 6 Thu-Fri, 7 Fri-Sat, 11 Sun, 12 Mon, 13 Tue, 14 Wed, 15 Thu, 16 Fri, 17 Sat) or a string such as "0000011", Monday to Sunday, where 1 is a day off.
holidays
Optional. A range of dates to skip.

WORKDAY.INTL examples

Every result below was calculated from this sample sheet by the same spreadsheet engine the Cellwise app uses.

ABCDE
1JobStartHoliday
2Shop fit-outNov 2, 2026Nov 26, 2026
3Nov 27, 2026

Download this sheet as an Excel practice file (.xlsx)

  1. =WORKDAY.INTL(B2,10,7)

    Result: Nov 16, 2026

    With a Friday and Saturday weekend, Sundays are working days and Fridays are not. Ten working days from Monday November 2 lands on Monday November 16.

  2. =WORKDAY.INTL(B2,10,11)

    Result: Nov 13, 2026

    A six-day week with only Sunday off finishes sooner: Friday November 13.

  3. =WORKDAY.INTL(B2,20,"0000011",$E$2:$E$3)

    Result: Dec 2, 2026

    The string "0000011" is the usual Saturday and Sunday weekend, written out. With the two holidays skipped, 20 working days end on December 2.

  4. =WORKDAY.INTL(B2,6,"1010101")

    Result: Nov 14, 2026

    A cleaner who works only Tuesday, Thursday and Saturday: the sixth working day after November 2 is Saturday November 14.

How to use WORKDAY.INTL

  1. Decide which days are off and pick the code or write the seven-digit string, Monday first.
  2. Type =WORKDAY.INTL(start,days,weekend,holidays).
  3. Press Enter and format the cell as a date.

Common WORKDAY.INTL mistakes

Starting the string on Sunday

The seven characters run Monday to Sunday. "0000011" means Saturday and Sunday off; "1000001" means Monday and Sunday off.

Writing the string as a number

Type the pattern in quotes, "0000011". Without quotes it becomes the number 11, which means Sunday only.

All days off

"1111111" leaves no working day, so WORKDAY.INTL returns #VALUE!. An unknown code such as 8 returns #NUM!.

WORKDAY.INTL FAQ

How do I use a Friday and Saturday weekend in Excel?

Use weekend code 7: =WORKDAY.INTL(start,days,7). For Friday only, use 16.

How do I count only certain days of the week?

Write a string with 0 for each working day and 1 for each day off, Monday first. "1010101" works Tuesday, Thursday and Saturday only.

Is WORKDAY.INTL the same as WORKDAY with code 1?

Yes. WORKDAY.INTL(start,days,1,holidays) gives the same result as WORKDAY(start,days,holidays).

Guides that use WORKDAY.INTL

Related functions

Updated