NETWORKDAYS(start_date, end_date [,holidays])

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

start_dateThe starting date.
end_dateThe finishing date.
holidays(Optional) An array of dates to exclude.

Remarks

* NETWORKDAYS.INTL was added in Excel 2010 to replace this function.
* This function excludes weekends and any other dates specified in the "holidays" array.
* This function has an explicit assumption that weekends are Saturday and Sunday. The NETWORKDAYS.INTL allows you to specify what days you want to treat as weekends.
* 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 WORKDAY to return the 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.office.com

 AB
1=NETWORKDAYS("1 Jan 2007","1 Jan 2007") = 11/1/2007
2=NETWORKDAYS("1 Jan 2007","2 Jan 2007") = 21/2/2007
3=NETWORKDAYS("1/1/2007","9/1/2007") = 71/3/2007
4=NETWORKDAYS(B1,B9) = 71/4/2007
5=NETWORKDAYS("1 Jan 2007","30 Jan 2007") = 221/5/2007
6=NETWORKDAYS("1 Jan 2007","31 Jan 2007") = 231/6/2007
7=NETWORKDAYS("1 Jan 2007","1 Feb 2007") = 241/7/2007
8=NETWORKDAYS("30 Jan 2007","02 Feb 2007") = 41/8/2007
9=NETWORKDAYS("31 Jan 2007","02 Feb 2007") = 31/9/2007
10=NETWORKDAYS("1 Jan 2007","31 Dec 2007") = 261 
11=NETWORKDAYS("14 Jan 2007","1 Jan 2007") = -10 
12=NETWORKDAYS(1/1/2007,31/12/2007) = 0 
13=NETWORKDAYS(DATE(2007,1,1),DATE(2007,12,31)) = 261 
14=NETWORKDAYS(DATE(2007,1,1),DATE(2007,12,31),"2 Jan 2007") = 260 
15=NETWORKDAYS(DATE(2007,1,1),DATE(2007,12,31),{"2 Jan 2007","3 Jan 2007"}) = 259 
16=NETWORKDAYS("1/30/1998","invalid dates") = #VALUE! 
17=NETWORKDAYS("some text","2007/12/01") = #VALUE! 

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top