Practice free

WORKDAY.INTL function

WORKDAY.INTL returns the date a given number of working days away, like WORKDAY, but lets you choose the weekend pattern. It suits regions with Friday and Saturday weekends or rotating shifts.

Example

Read it as a sentence: find the workday 1 day after January 16, 2026, using weekend code 1 for Saturday and Sunday off and skipping the holidays in H1:H3, which gives 46042.

Practice this in the app

Syntax

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

Arguments in [square brackets] are optional.

start_date (required)
Starting date.
days (required)
Working days to move.
weekend (optional)
Number code or 7-character 0/1 string (starting Monday) defining weekend days.
holidays (optional)
Optional list of dates to skip.

Returns: The date a given number of working days away, with a custom weekend.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=WORKDAY.INTL(DATE(2026,1,8),1,7) 46033 Friday-Saturday weekend
=WORKDAY.INTL(DATE(2026,1,8),1,"0000110") 46033 String weekend
=WORKDAY.INTL(DATE(2026,1,9),-3,11) 46028 Sunday-only weekend backwards
=WORKDAY.INTL(DATE(2026,1,16),1,1,Data!H1:H3) 46042 Holidays
=WORKDAY.INTL(DATE(2026,1,8),1,"1111111") #VALUE! All weekend
=WORKDAY.INTL(DATE(2026,1,8),1,99) #NUM! Bad code

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • Code 11 is Sunday only; code 7 is Friday and Saturday.
  • In the string, 1 means non-working and the first character is Monday.

Where it works

Excel
WORKDAY.INTL arrived in Excel 2010. Older versions do not have it.
Google Sheets
Same name, same behaviour for everyday use.

Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .