Excel Function : NETWORKDAYS.INTL

Download now!

Excel Function : NETWORKDAYS.INTL

Category

Date and time

Description

Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days

Microsoft Excel Reference Page

https://support.office.com/en-us/article/NETWORKDAYSINTL-function-a9b26239-4f20-46a1-9ab8-4e925bfd5e28

Syntax and Description of the NETWORKDAYS.INTL Excel Function

The syntax for the NETWORKDAYS.INTL function in Microsoft Excel is: NETWORKDAYS.INTL( start_date, end_date, [weekend], [holidays] ) Arguments start_date - The start date for the calculation. end_date - The end date for the calculation. weekend - An optional integer that specifies which days of the week are considered weekends. The default is 1 for Saturday and Sunday. holidays - An optional range of cells that contains dates that should be excluded from the working days.

About NETWORKDAYS.INTL Excel Function

NETWORKDAYS.INTL(start_date,end_date,weekend,holidays) The NETWORKDAYS.INTL function calculates the number of network days (workdays) between two dates, based on your own custom weekend and holidays rules. Start_date and end_date are the two dates between which you want to calculate the number of workdays. Weekend is a number code that represents which days of the week are considered weekend days. For example, 1 represents Sunday, 2 represents Monday, 7 represents Saturday, and 11 represents Sunday and Monday. Holidays is an optional list of dates that should be excluded from the workday calculation.