The NETWORKDAYS.INTL function calculates the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. Weekend days and any days that are specified as holidays are not considered as workdays.

NETWORKDAYS.INTL takes 2 required arguments and 2 optional arguments:

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

#1)
Using the NETWORKDAYS.INTL function:
#2)
The arguments for the NETWORKDAYS.INTL function are:
Argument Required? Description
start_date Required A date that represents the start date.
end_date Required A date that represents the end date.
weekend Optional Indicates the days of the week that are weekend days and are not included in the number of whole working days between start_date and end_date. Weekend is a weekend number or string that specifies when weekends occur. Weekend number values indicate the following weekend days:
Possibleweekendargument values:
holidays Optional An optional range of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells that contains the dates or an array constant of the serial numbers that represent the dates.
#3)
A few more things:
If start_date is later than end_date, the return value will be negative, and the magnitude will be the number of whole workdays.
If start_date is out of range for the current date base value, NETWORKDAYS.INTL returns the #NUM! error value.
If end_date is out of range for the current date base value, NETWORKDAYS.INTL returns the #NUM! error value.
If a weekend string is of invalid length or contains invalid characters, NETWORKDAYS.INTL returns the #VALUE! error value.

Summary

The NETWORKDAYS.INTL function calculates the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. Weekend days and any days that are specified as holidays are not considered as workdays.
comments powered by Disqus