How To Use: NETWORKDAYS.INTL function in Excel -Simplified

Share
Embed
  • 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.
    _________________________________________________________________
    Syntax
    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.
    _________________________________________________________________

    Remarks
    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.

Comments • 0