Function Reference: NETWORKDAYS.INTL and NETWORKDAYS
| Syntax | ||||||||||||||||||||||||||||||
| =NETWORKDAYS.INTL(start_date,end_date,[weekend],[public_holidays]) =NETWORKDAYS(start_date,end_date,[public_holidays]) |
||||||||||||||||||||||||||||||
| Purpose / Description | ||||||||||||||||||||||||||||||
| Returns the net number of working days between two dates, inclusive of both the starting and ending date. May optionally include a list of holiday dates, which in addition to weekends, are considered non-working days. NETWORKDAYS.INTL allows you to specify the weekend days whereas NETWORKDAYS assumes the weekend is Saturday and Sunday. | ||||||||||||||||||||||||||||||
| Arguments | ||||||||||||||||||||||||||||||
| Name | Type | Description | ||||||||||||||||||||||||||||
| start_date | number | A constant, reference or nested expression which provides the serial date number from which the number of working days elapsed is calculated. Any decimal portion, assumed to be time of day is ignored. | ||||||||||||||||||||||||||||
| end_date | number | A constant, reference or nested expression which provides the serial date number to which the number of working days elapsed is calculated. Any decimal portion, assumed to be time of day is ignored. | ||||||||||||||||||||||||||||
| [public_holidays] | array of numbers | An optional constant, array of constants, range reference or nested expression that provides one or more serial date numbers which are to be considered non-working days in calculating the number of working days between start_date and end_date. Any decimal portion, assumed to relate to time of day is ignored. | ||||||||||||||||||||||||||||
| [weekend] | number | For NETWORKDAYS.INTL only, this is an optional constant, reference or nested expression which indicates which days are to be considered non-working days. Defaults to 1 if omitted
|
||||||||||||||||||||||||||||
| Return Values | ||||||||||||||||||||||||||||||
| Type | Specific Value | Description | ||||||||||||||||||||||||||||
| number | The count of working days elapsed between start_date and end_date inclusively. If end_date is an earlier date than start_date, the value returned is negative. |
|||||||||||||||||||||||||||||
| error | #VALUE! | If any of the arguments are not numbers and cannot be coerced to number. | ||||||||||||||||||||||||||||
| error | #NUM! | If the number passed to start_date or end_date is outside the range allowed. 1900 date system: 0 to 2,958,465 1904 date system: 0 to 2,957003 |
||||||||||||||||||||||||||||
| error | Any errors referenced by arguments are returned due to propagation of error values. | |||||||||||||||||||||||||||||
| Notes / Comments / Advice / Warnings | ||||||||||||||||||||||||||||||
| Advice: | We advise using NETWORKDAYS.INTL if doing this type of calculation, as it keeps the idea front of mind that you can adjust the weekend / no-trading days. | |||||||||||||||||||||||||||||
| Advice: | If the order of the dates you are calculating on is unknown, i.e. the end dates could be earlier than the start dates, and you only wish the numerical number of days, next the function in an ABS function, which will return the absolute value only, so no negative values will be returned. | |||||||||||||||||||||||||||||
| Caution: | If you are calculating non-inclusively of the starting date, i.e. how many working days after that date, it is not safe to simply subtract 1 from the result. If start_date is a weekend date or a public holiday, it is already excluded from the result. | |||||||||||||||||||||||||||||
| Examples: | Open / download sample workbook:: NETWORKDAYS.INTL, NETWORKDAYS.xlsx | |||||||||||||||||||||||||||||