Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters. Weekend parameters indicate which and how many days are weekend days. Weekend days and any days that are specified as holidays are not considered as workdays.
A date that represents the first, or starting, date of the period.
The number of workdays before or after the start_date.
An optional argument that indicates the days of the week that are weekend days and are not considered working days.
An optional set of one or more dates to exclude from the working day calendar.
To view the serial number as a date, select the cell, and then on the View menu, click Formatting Palette. Under Number, on the Format pop-up menu, click Date.
If start_date plus day-offset yields an invalid date, WORKDAY.INTL returns the #NUM! error value.
Weekend number values indicate the following weekend days:
1 or omitted
Weekend string values are seven characters long and each character in the string represents a day of the week, starting with Monday. 1 represents a non-workday and 0 represents a workday. Only the characters 1 and 0 are permitted in the string. Using 1111111 will always return 0. For example, 0000011 would result in a weekend, that is Saturday and Sunday.
To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.
|Tip To format the numbers that are returned as dates, select them, click Format, click Cells, and then click the Number tab. Under Category, click Date, and then under Type, select a type of date formatting that you want to use.|