Author: Oscar Cronquist Article last updated on April 19, 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:


Excel Function Syntax

NETWORKDAYS(start_date, end_date, [holidays])


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.