|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.|
|* 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.
* Added in Excel 2010.
* For the Microsoft documentation refer to support.microsoft.com
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top