NETWORKDAYS.INTL function

Returns the number of whole workdays between two dates using parameters to 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

NETWORKDAYS.INTL(start_date,end_date,weekend,holidays)

Argument	Description	Remarks
start_date	The dates for which the difference is to be computed.	The start_date argument can be earlier than, the same as, or later than the end_date argument. If start_date is later than end_date, the return value will be negative, and the magnitude will be the number of whole workdays. If argument is out of range for the current date base value, this function returns the #NUM! error value.
end_date	The dates for which the difference is to be computed.	If argument is out of range for the current date base value, this function returns the #NUM! error value.
weekend	An optional argument that indicates the days of the week that are weekend days and are not included in the number of whole working days between start_date and end_date.	Weekend is a weekend number or string that specifies when weekends occur. If a weekend string is of invalid length or contains invalid characters, this function returns the #VALUE! error value.
holidays	An optional set of one or more dates that are to be excluded from the working day calendar.	Holidays shall be a range of cells that contain the dates, or an array constant of the serial values that represent those dates. The ordering of dates or serial values in holidays can be arbitrary.

General remarks

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.

A	B
Formula	Description
=NETWORKDAYS.INTL(DATE(2006,1,1),DATE(2006,1,31))	Results in 22 (31 days; 5 Saturdays, 4 Sundays)
=NETWORKDAYS.INTL(DATE(2006,1,31),DATE(2006,1,1))	Results in -22
=NETWORKDAYS.INTL(DATE(2006,1,1),DATE(2006,2,1),7,{"2006/1/2","2006/1/16"})	Results in 22 (32 days; 4 Fridays, 4 Saturdays, 2 Holidays)
=NETWORKDAYS.INTL(DATE(2006,1,1),DATE(2006,2,1),"0000110",{"2006/1/2","2006/1/16"})	Results in 22

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

Share your feedback about this topic

Rate this content: