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

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

start_dateThe starting date.
end_dateThe finishing date.
weekend(Optional) A 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
holidays(Optional) An array of dates to exclude.

Remarks

* Added in Excel 2010.
* This function replaces the NETWORKDAYS function.
* 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. For example 0000011 represents 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 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 instead.
* For the Microsoft documentation refer to support.office.com

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


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