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.
A number representing days.
=NETWORKDAYS (start_date, end_date, [holidays])
|Start date||The start date||Mandatory|
|end date||The end date||Mandatory|
|holidays||A list of non-work days as dates||Optional|
- 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.