NETWORKDAYS.INTL()
Syntax. NETWORKDAYS.INTL(start_date,end_date,weekend,holidays)
Definition. This function returns the number of workdays within the given time interval. Weekend days and any days that are specified as holidays are not considered as workdays.
Arguments
start_date (required). The date that represents the start of the time interval.
end_date (required). The date that represents the end of the time interval.
weekend (optional). A number or string indicating which days are weekends and should not be treated as workdays.
holidays (optional). An array of one or more dates defining nonworking days to exclude from the calculation, such as federal holidays and floating holidays. The array can be a cell range containing the dates or an array ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.