Using the Excel NETWORKDAYS.INTL Function
SummaryThe NETWORKDAYS.INTL function in Excel is similar to the NETWORKDAYS function with the added benefit that NETWORKDAYS.INTL allows you to specify weekend days. Once executed, the function will return the number of full working days between the provided start and end dates. Working days do not include specified weekends and days declared as holidays. If no weekend days are specified, NETWORKDAYS.INTL will default to excluding Saturday and Sunday.
Syntax=NETWORKDAYS.INTL (start_date, end_date, [weekend], [holidays])
Start_date is a required field. When entering dates be sure to use a function, such as DATE, to enter values as errors may occur if dates are entered as text.
End_date is a required field that represents the ending date.
Weekend is an optional field and allows the user to specify days that are considered weekend days. Weekend days will not be included in the working day count between start and end dates.
The weekend value is supplied as a seven digit string that specifies when the weekend occurs. The string always begins with Monday and each digit represents a day of the week. 1 is used to denote a non-working day and 0 denotes a working day.
For example, if you wanted to set Monday and Tuesday as non-working (weekend) days the string would look like the following:
Excel also provides values to indicate a specific day or days as a weekend day. The values provided are as follows:
The holiday field is optional and allows the user to specify a day or days that should not be counted as working days since they are a holiday. Dates can be entered as values in individual cells or as an array constant.
Usage NotesNegative Value Returned
It is possible for the function to return a negative value. If start_date is after end_date, then a negative result will display. This may be useful if you are trying to calculate working days in the past for payroll or other purposes.
#VALUE! and #NUM! Errors
NETWORKDAYS.INTL will return the #VALUE! error if the weekend input is not valid. The function will also return the #NUM! error if either start_date or end_date (or both) are out of a valid range. Remember that Excel only accepts dates from January 1, 1900 - December 31, 9999.