NETWORKDAYS.INTL

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

Returns the total number of working days between two dates excluding weekends and holidays.

start_date	The starting date.
end_date	The finishing date.
weekend	(Optional) The number indicating which days to consider weekends: 1 = Saturday and Sunday (default) 2 = Sunday and Monday 3 = Monday and Tuesday 4 = Tuesday and Wednesday 5 = Wednesday and Thursday 6 = Thursday and Friday 7 = Friday and Saturday 11 = Sunday only 12 = Monday only 13 = Tuesday only 14 = Wednesday only 15 = Thursday only 16 = Friday only 17 = Saturday only String Representation (eg 0000011)
holidays	(Optional) An array of dates to exclude.

REMARKS

* This function replaces the NETWORKDAYS function which had an explicit assumption about weekends.
* This function can be used to calculate holiday entitlement that is based on the number of days worked during a specific period.
* If "start_date" contains any time information, it is ignored.
* If "start_date" > "end_date", then the result will be negative.
* If "start_date" is out of range, then #NUM! is returned
* If "end_date" contains any time information, it is ignored.
* If "end_date" is out of range, then #NUM! is returned.
* If "holidays" is left blank, then only weekends will be excluded.
* The "weekend" can also use a string representation for your weekend.
* The string must be 7 characters and only contain characters 1 and 0. A 1 represents a non-working day and a 0 represents a working day.
* An example of a valid string representation would be 0000111 that would exclude Friday, Saturday and Sunday.
* If "weekend" is not recognised, then #VALUE! is returned.
* If "weekend" is an invalid string, then #VALUE! is returned.
* Holidays can be an array or a range of cells.
* You can use the DATE function to return the date as a date serial number given a year, month, day.
* You can use the DATEVALUE function to return the date serial number given a date in text format.
* You can use the WORKDAY.INTL function if you want the number of working days between two dates.
* You can use the NETWORKDAYSMISC - User Defined Function if you want to use a VBA function.
* This function was added in Excel 2010
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B
1	=NETWORKDAYS.INTL("1 Jan 2021", "1 Jan 2021") = 1	Saturday, January 01, 2022
2	=NETWORKDAYS.INTL("1 Jan 2022", "1 Jan 2022") = 0	Sunday, January 02, 2022
3	=NETWORKDAYS.INTL("1 Jan 2023", "2 Jan 2023") = 1	Monday, January 03, 2022
4	=NETWORKDAYS.INTL("1/1/2023", "9/1/2023") = 6	Tuesday, January 04, 2022
5	=NETWORKDAYS.INTL(B1, B9) = 5	Wednesday, January 05, 2022
6	=NETWORKDAYS.INTL("1 Jan 2022", "30 Jan 2022") = 20	Thursday, January 06, 2022
7	=NETWORKDAYS.INTL("1 Jan 2022", "31 Jan 2022") = 21	Friday, January 07, 2022
8	=NETWORKDAYS.INTL("1 Jan 2022", "1 Feb 2022") = 22	Saturday, January 08, 2022
9	=NETWORKDAYS.INTL("30 Jan 2022", "02 Feb 2022") = 3	Sunday, January 09, 2022
10	=NETWORKDAYS.INTL("31 Jan 2022", "02 Feb 2022") = 3
11	=NETWORKDAYS.INTL("1 Jan 2022", "31 Dec 2022") = 260
12	=NETWORKDAYS.INTL("14 Jan 2022", "1 Jan 2022") = -10
13	=NETWORKDAYS.INTL(1/1/2022, 31/12/2022) = 0
14	=NETWORKDAYS.INTL(DATE(2022, 1, 1), DATE(2022, 12, 31)) = 260
15	=NETWORKDAYS.INTL("1 Jan 2022", "31 Dec 2022", "0000111") = 208
16	=NETWORKDAYS.INTL(DATE(2022, 1, 1), DATE(2022, 12, 31), "2 Jan 2022") = #VALUE!
17	=NETWORKDAYS.INTL(DATE(2022, 1, 1), DATE(2022, 12, 31), {"2 Jan 2022", "3 Jan 2022"}) = #VALUE!	#VALUE!
18	=NETWORKDAYS.INTL("1/30/2023", "invalid dates") = #VALUE!
19	=NETWORKDAYS.INTL("some text", "2023/12/01") = #VALUE!