WorksheetFunction.NetworkDays (Excel)

Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NetworkDays to calculate employee benefits that accrue based on the number of days worked during a specific term.

NetworkDays (Arg1, Arg2, Arg3)

Dim dblNetworkDays As Double
dblNetworkDays = WorksheetFunction.NetworkDays(Arg1:=, Arg2:=)

Arguments

Arg1 - Start_date - a date that represents the start date

Arg2 - End_date - a date that represents the end date

Arg3 - Holidays - an optional range of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells that contains the dates or an array constant of the serial numbers that represent the dates