Excel Functions

Excel NETWORKDAYS Function

Pinterest LinkedIn Tumblr

The NETWORKDAYS function calculates the number of working days between two dates. NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and can optionally exclude a list of holidays supplied as dates.

Purpose of Excel NETWORKDAYS Function

To get number of working days.

Return value

A number representing days.


=NETWORKDAYS (start_date, end_date, [holidays])


Start dateThe start dateMandatory
end dateThe end date Mandatory
holidaysA list of non-work days as datesOptional

Usage notes

  • This function counts the number of working days (business days) between two dates, automatically excluding weekends (Saturday and Sunday) and optionally excluding holidays.


Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment