<< Click to Display Table of Contents >> WORKDAY.INTL (date after x workdays)

Syntax:

WORKDAY.INTL(StartDate; Days [; Weekend] [; Holidays])

Description:

This determines the date that is x workdays before or after the StartDate. This function counts workdays only by default and Saturdays and Sundays are skipped.

You have the option of entering weekend parameters to define exactly which weekdays should be skipped. You also have the option of specifying a list of holidays. These will also be skipped.

Note: WORKDAY.INTL is a more flexible variant of the WORKDAY function, as the weekend parameter can be defined individually.

StartDate is the start date.

Days is the number of workdays. A positive value will return a date in the future, while a negative value will return a date in the past.

For Weekend, you have the option of setting which weekdays are considered weekends. If omitted, the default value 1 is used (Saturday, Sunday). See the two lists below for all parameters.

Holidays (optional) is a cell range or an array containing a list of dates to be skipped (for example, holidays). (This is usually done using a cell range or an array containing the corresponding date values.)

An even more flexible method of defining weekends is a 7-digit string of ones and zeros. Each character in the 7-digit string stands for a day of the week: the first character stands for Monday, the second for Tuesday, etc. The 0 represents a normal work day and the 1 represents a weekend day.

Example:

Calendar sheet October 2022 (for better orientation)

WORKDAY.INTL("10/1/2022", 9) returns 10/13/2022.

The date that comes 9 work days after 10/1/2022 is thus 10/13/2022.

WORKDAY.INTL("10/1/2022", 9, 7) returns 10/12 instead of 10/13, since the weekend value 7 (Friday, Saturday) means that Sunday 10/2 is no longer considered a weekend day and Friday 9/30 as the weekend day is before the start date.

With the 7-digit string, the same formula would look like this:

WORKDAY.INTL("10/01/2022", 9; "0000110") returns 10/12 instead of 10/13

However, 10/3/2022 was a holiday in Germany. If you wanted to take this into account, you would have to write:

WORKDAY.INTL("10/1/2022", 9, 1, "10/3/2022") – which results in 10/14 instead of 10/13, since the holiday on 10/3 fell on a weekday and thus is skipped in the count. For the weekend days, the default value (1 = Saturday, Sunday) was used here again.

See also:

WORKDAY, HOLIDAY, NETWORKDAYS, NETWORKDAYS.INTL