The WORKDAY. INTL Function in Excel

This guide provides a practical overview of WORKDAY. INTL Function, including its main features, benefits, limitations, and important considerations.

The WORKDAY. INTL Function in Excel screenshot

Description: The function returns a date before or after the start of a specified number of working days with a custom weekend. The weekend parameter indicates which day and how many days.

Syntax: WORKDAY (start_date, days, [weekend], [holidays])

Inside:

- start_date: The start date, is a required parameter.

- days: A day not in the weekend and holidays before or after start_date, is a required parameter.

+ days> 0 -> number of days generated in the future.

+ days <0 -> number of days created in the past.

- weekend: Indicates which days are weekends not included in the working day, are optional parameters with the following values:

+ weekend = 1 -> The weekend is Saturday and Sunday.

+ weekend = 2 -> The weekend is Sunday, Monday.

+ weekend = 3 -> Weekends are Monday and Tuesday.

+ weekend = 4 -> Weekends are Tuesday and Wednesday.

+ weekend = 5 -> Weekends are Wednesdays and Thursdays.

+ weekend = 6 -> Weekends are Thursday and Friday.

+ weekend = 7 -> Weekends are Friday and Saturday.

+ weekend = 11 -> Weekends are only Sunday.

+ weekend = 12 -> Weekends are only Monday.

+ weekend = 13 -> Weekends are only Tuesday.

+ weekend = 14 -> Weekends are only Wednesday.

+ weekend = 15 -> Weekends are only Thursday.

+ weekend = 16 -> Weekends are only Friday.

+ weekend = 17 -> Weekends only Saturday.

- holidays: Days to be excluded from working days which are not on public holidays.

Attention:

- Excel stores dates as sequential serial numbers to facilitate the calculation process.

- Any one of the arguments is invalid -> the function returns the #VALUE! Error value

- If start_date + days value creates an invalid date -> the function returns the #NUM! Error value

- If days is a decimal, it is truncated to an integer.

For example:

Calculate the day after the working day a certain number of days, weekends are defined by the values in the weekend column of the following jobs:

The WORKDAY. INTL Function in Excel screenshot 2

- In the cell to calculate, enter the formula: = WORKDAY. INTL (F7, G7, H7, I7).

The WORKDAY. INTL Function in Excel screenshot 3

- Press Enter -> return value is:

The WORKDAY. INTL Function in Excel screenshot 4

- Similarly copying the formula for the remaining value results:

The WORKDAY. INTL Function in Excel screenshot 5

Above are instructions and some specific examples when using the WORKDAY. INTL function in Excel.

Good luck!

FAQ

What does the WORKDAY. INTL Function function do in Excel?

The WORKDAY. INTL Function function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.

How do I enter the WORKDAY. INTL Function function correctly?

Start with an equals sign, enter WORKDAY. INTL Function, add the required arguments inside parentheses, and confirm that cell references and separators are correct.