WORKDAY.INTL function

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.

Syntax

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

Argument	Description	Remarks
start_date	A date that represents the first, or starting, date of the period.	If start_date is out of range for the current date base value, WORKDAY.INTL returns the #NUM! error value. If this argument contains a decimal value, this function ignores the numbers to the right side of the decimal point.
days	The number of workdays before or after the start_date.	A positive value for days yields a future date; a negative value yields a past date; a zero value yields the start_date. If start_date plus days yields an invalid date, WORKDAY.INTL returns the #NUM! error value. If a valid date is not entered for this argument, this function returns the #VALUE! error value. If this argument contains a decimal value, this function ignores the numbers to the right side of the decimal point.
weekend	An optional argument that indicates the days of the week that are weekend days and are not considered working days.	Weekend is a weekend number or string that specifies when weekends occur. If a weekend string is of invalid length or contains invalid characters, WORKDAY.INTL returns the #VALUE! error value.
holidays	An optional set of one or more dates to exclude from the working day calendar.	The list can be either a range of cells that contain the dates or an array constant of the serial numbers that represent the dates. The ordering of dates or serial values in holidays can be arbitrary. If any date in holidays is out of range for the current date base value, WORKDAY.INTL returns the #NUM! error value.

General remarks

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:

WEEKEND NUMBER	WEEKEND DAYS
1 or omitted	Saturday, Sunday
2	Sunday, Monday
3	Monday, Tuesday
4	Tuesday, Wednesday
5	Wednesday, Thursday
6	Thursday, Friday
7	Friday, Saturday
11	Sunday only
12	Monday only
13	Tuesday only
14	Wednesday only
15	Thursday only
16	Friday only
17	Saturday only

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.

Example

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.


1
2
3
4
5
6
7

A	B
Formula	Description
=WORKDAY.INTL(DATE(2006,1,1),0)	Results in a serial value corresponding to 1-Jan-2006
=WORKDAY.INTL(DATE(2006,1,1),10)	Results in a serial value corresponding to 13-Jan-2006
=WORKDAY.INTL(DATE(2006,1,1),10,7)	Results in a serial value corresponding to 13-Jan-2006
=WORKDAY.INTL(DATE(2006,1,1),-10)	Results in a serial value corresponding to 19-Dec-2005
=WORKDAY.INTL(DATE(2006,1,1),20,1,{"2006/1/2","2006/1/16"})	Results in a serial value corresponding to 31-Jan-2006
=WORKDAY.INTL(DATE(2006,1,1),20,"0000011",{"2006/1/2","2006/1/16"})	Results in a serial value corresponding to 31-Jan-2006

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.

See also
EDATE function
EOMONTH function
NETWORKDAYS.INTL function
NOW function
List of all functions (by category)

Share your feedback about this topic

Rate this content: