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