Article updated on January 18, 2018

The NETWORKDAYS function returns the number of working days between two dates, excluding weekends. It also allows you to ignore a list of holiday dates that you can specify.

Formula in cell D3:

=NETWORKDAYS(B3,C3, B6:B7)

Excel Function Syntax

NETWORKDAYS(start_date, end_date, [holidays])

Arguments

start_date Required. The start date you want to use in the function.
end_date Required. The end date you want to use.
[holidays] Optional. Excludes this list of dates from being counted.