NETWORKDAYS

NETWORKDAYS(start_date, end_date [,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.
holidays	(Optional) An array of dates to exclude.

REMARKS

* NETWORKDAYS.INTL was added in Excel 2010 to replace this function.
* The NETWORKDAYS.INTL function allows you to specify what days you want to treat as weekends.
* This function has an explicit assumption that weekends are Saturday and Sunday.
* This function excludes weekends and any other dates specified in the "holidays" array.
* Both the "start_date" and the "end_date" are included in the total count.
* If "start_date" is not a valid date, then #VALUE! is returned.
* If "end_date" is not a valid date, then #VALUE! is returned.
* If "holidays" is left blank, then only weekends will be excluded.
* The "holidays" allows you to specify bank holidays as well as any other floating holidays.
* The "holidays" can either be range of cells containing dates or an array constant of serial numbers.
* If "holidays" contains anything that is not a valid date, then #NUM! is returned.
* 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 to return the date serial number that is a given number of working days before or after a date.
* You can use the NETWORKDAYSMISC - User Defined Function to return the number of days between two dates using a defined list of workdays.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

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

1 - How many working days are there between 1 Jan 2021 and 1 Jan 2021. This day was a Friday.
2 - How many working days are there between 1 Jan 2022 and 1 Jan 2022. This day was a Saturday.