Date and time functions WORKDAY.INTL function

WORKDAY.INTL < span style="font-size: 16px; ">Formula syntax and usage of functions

Returns the serial number for a date that is a specified number of business days before or after (using a custom weekend parameter).

The weekend parameter specifies how many days there are on the weekend and which days they are.

Weekends and any days designated as holidays are not considered business days.

Grammar

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

WORKDAY.INTL function syntax has the following parameters:

▪Start_date Required. Start date (will be truncated).

▪Days Required. Start_date The number of business days before or after. A positive value represents a date in the future; a negative value represents a date in the past; a value of zero represents a start date. Day-offset will be truncated.

▪weekend Optional. Indicates days of the week that are weekends and days that are not working days. Weekend is a weekend number or string that specifies the weekend day.

weekendThe values ​​represent the following weekend days:

The weekend string value is seven characters long, and each character in the string represents a day of the week (starting on Monday).

1 means non-working days, 0 indicates working days. Only the characters 1 and 0 are allowed in the string. 1111111 is an invalid string.

For example, 0000011 results in Saturday and Sunday being the weekend.

▪holidays Optional. An optional set of dates representing one or more dates to exclude from the weekday calendar. holidays should be a range of cells containing the relevant dates, or an array constant consisting of sequence values ​​representing those dates. The order of dates or sequence values ​​in holidays can be arbitrary.

Remarks

▪If start_date is outside the range of the current date base value, the function WORKDAY.INTL will return the error value #NUM!.

▪ If any date in holidays is outside the range of the current date base value, the function WORKDAY.INTL will return the #NUM! error value.

▪ If start_date plus day-offset results in an invalid date, function WORKDAY.INTL will return the #NUM! error value.

▪If the weekend string has an invalid length or contains invalid characters, the function WORKDAY.INTL will return the #VALUE! error value.

Example