Quick Answer

WORKDAY.INTL Function

Returns a date n workdays away with a custom weekend.

✓ Excel✓ Google SheetsExcel Excel 2010+

Syntax

WORKDAY.INTL

(start_date, days, [weekend], [holidays])

Parameters

Parameter	Description	Required
start_date	The starting date serial.	Required
days	The number of workdays to move. Positive moves forward, negative moves backward. The start date itself is not counted.	Required
weekend	Optional. A number 1-7 or 11-17 selecting weekend days (1 = Sat+Sun default, 2 = Sun only, 3 = Mon only, ... 7 = Fri only, 11 = Sun+Mon, ... 17 = Sat+Sun), or a 7-character string of 0/1 for Mon-Sun where 1 means weekend.	Optional
holidays	Optional range or array of dates to exclude as non-working days.	Optional

Basic Example

Five workdays after Jan 1, 2024 (default Sat/Sun weekend)

=WORKDAY.INTL(DATE(2024, 1, 1), 5, 1)

Result45298

With the default weekend (code 1, Sat+Sun), five workdays from Monday Jan 1 land on Monday Jan 8 2024 (serial 45298).

Advanced Examples

Example 1: Custom weekend via string (Mon and Sun off)

A schedule where Monday and Sunday are non-working

A 7-character string sets the weekend pattern

=WORKDAY.INTL(DATE(2024, 1, 1), 5, "1000001")

Result: 45296

The string "1000001" marks Monday and Sunday as weekends (Mon-Sun order). Five workdays from Jan 1 land on Saturday Jan 6 (serial 45296), since Mon and Sun are skipped.

Example 2: Sunday-only weekend via code

A six-day work week

Weekend code 2 treats only Sunday as non-working

=WORKDAY.INTL(DATE(2024, 1, 1), 5, 2)

Result: 45295

With only Sunday off, five consecutive workdays (Jan 1-5, none of which is Sunday) land on Friday Jan 5 2024 (serial 45295).

How WORKDAY.INTL Works

WORKDAY.INTL walks from start_date counting only days that are not designated weekends by the weekend argument, also skipping listed holidays, until it reaches the requested number of workdays. The weekend can be a preset code or a 7-character 0/1 string in Monday-to-Sunday order.

Enter the start date

Provide a date serial or DATE(...) expression.

Enter the number of workdays

Use a positive or negative integer.

Set the weekend

Use a code (1-7/11-17) or a 7-char 0/1 string (Mon-Sun).

Optionally list holidays

Pass a range or array of holiday dates.

Important Notes & Limitations

Available only in Excel 2010 and later.
The weekend string must be exactly seven characters in Monday-to-Sunday order.
The start date itself is not counted toward the days total.

Common Errors & Fixes

#VALUE!The weekend string is not exactly seven 0/1 characters.

Fix: Use a valid 7-character string such as "0000011".

#NUM!An invalid weekend code (not 1-7 or 11-17) was supplied.

Fix: Use a supported weekend code or a valid string.

Download Practice File

Practice WORKDAY.INTL with Real Data

Download a sample CSV file with pre-populated data and practice exercises for the WORKDAY.INTL function. Works in both Excel and Google Sheets.

Works in Google SheetsCompatible with ExcelIncludes exercises

File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps

Frequently Asked Questions

What does the weekend string mean?

It is seven characters for Mon, Tue, Wed, Thu, Fri, Sat, Sun, where 1 marks a weekend day, e.g. "0000011" = Sat+Sun off.

Which code is the default?

Code 1, meaning Saturday and Sunday are weekends.

How do I make Friday and Saturday the weekend?

Use code 7 or the string "0000110".