How To Use: NETWORKDAYS.INTL function in Excel -Simplified
- Published on Aug 5, 2016
- Returns 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(start_date, end_date, [weekend], [holidays])
The NETWORKDAYS.INTL function syntax has the following arguments:
Start_date and end_date Required. The dates for which the difference is to be computed. The start_date can be earlier than, the same as, or later than 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.
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.
Thanks for watching. do subscribe to our channel.