Excel Function : NETWORKDAYS

Download now!

Excel Function : NETWORKDAYS

Category

Date and time

Description

Returns the number of whole workdays between two dates

Microsoft Excel Reference Page

https://support.office.com/en-us/article/NETWORKDAYS-function-48e717bf-a7a3-495f-969e-5005e3eb18e7

Syntax and Description of the NETWORKDAYS Excel Function

The syntax for the NETWORKDAYS function in Microsoft Excel is: NETWORKDAYS( start_date, end_date, [holidays] ) start_date is the start date of the period. end_date is the end date of the period. [holidays] is an optional list of dates to exclude from the calculation.

About NETWORKDAYS Excel Function

The NETWORKDAYS function calculates the number of whole workdays between two dates.