ExcelDateIntermediate

WORKDAY.INTL

Returns the date before or after a specified number of workdays, using custom weekend parameters.

Read the syntaxReview worked examplesOpen the spreadsheet app
=WORKDAY.INTL(start_date, days, [weekend], [holidays])
Open Spreadsheet Explorer

This static page keeps the function indexed for search, while the spreadsheet app handles interactive exploration and saved formulas.

What the function does

Overview

Returns the date before or after a specified number of workdays, using custom weekend parameters.

The WORKDAY.INTL function calculates a future or past date by adding or subtracting a specified number of workdays from a `ate`, allowing for custom weekend days and an optional list of `holidays`. This function is highly flexible for project scheduling and deadline calculations, especially in international contexts where weekend days vary. The `ate` must be a valid Excel date. `days` is the number of workdays to add or subtract; a positive value moves forward, a negative value moves backward. The `weekend` argument is crucial: it can be a number (1-7 for standard weekends, 11-17 for single-day weekends) or a 7-character string (e.g., "0000011" for Saturday/Sunday, where 0 means workday and 1 means weekend). The optional `holidays` argument is a range of dates to exclude from workdays. Understanding the `weekend` argument's numeric and string options is key to correctly applying this function for diverse workweek definitions, ensuring accurate project timelines.

Quick reference

Syntax

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

Inputs

Arguments

start_dateThe start date from which to calculate the workday.
Example: A2
daysThe number of non-weekend and non-holiday days before or after 'start_date'.
Example: 10
weekend (optional)[Optional] A number or string indicating which days are weekend days. E.g., 1 (Sat/Sun), 11 (Sun only), or "0000011" (Sat/Sun).
Example: 11
holidays (optional)[Optional] An optional set of one or more dates to exclude from the workday calendar.
Example: B2:B5

Formula patterns

Examples

1

Adding 10 workdays with custom weekend (Sunday only)

=WORKDAY.INTL("2023-01-01", 10, 11)
project schedulingcustom weekend
2

Subtracting 5 workdays with custom weekend (Friday/Saturday) and holidays

=WORKDAY.INTL(A2, -5, "0000110", B2:B5)
deadline calculationinternational calendar

Avoid these issues

Common Errors

1

#VALUE!

Cause: The 'start_date' or any date in 'holidays' is not a valid Excel date, or the 'weekend' string is invalid.

Fix: Ensure all date arguments are valid and the 'weekend' argument follows the specified numeric or string format.

2

#NUM!

Cause: The 'days' argument results in a date outside Excel's valid date range (January 1, 1900, to December 31, 9999).

Fix: Adjust the 'start_date' or 'days' argument to fall within Excel's valid date range.

Platform support

Compatibility

Excel 2010+Google Sheets

Available in Excel 365 and 2010+.

Source: Microsoft Support

Common questions

Frequently Asked Questions

Returns the date before or after a specified number of workdays, using custom weekend parameters.

ate: The start date from which to calculate the workday. days: The number of non-weekend and non-holiday days before or after 'ate'. weekend: [Optional] A number or string indicating which days are weekend days. E.g., 1 (Sat/Sun), 11 (Sun only), or "0000011" (Sat/Sun). holidays: [Optional] An optional set of one or more dates to exclude from the workday calendar.

#VALUE!: Ensure all date arguments are valid and the 'weekend' argument follows the specified numeric or string format. #NUM!: Adjust the 'ate' or 'days' argument to fall within Excel's valid date range.