# NETWORKDAYS Function in Excel – Calculate number of working days between two dates

NETWORKDAYS Function in Excel calculates the number of working days between two dates. NETWORKDAYS Function automatically excludes weekends (Saturday and Sunday) and it can also exclude list of holidays that is provided as an input

#### Syntax for NETWORKDAYS Function in Excel

NETWORKDAYS (start_date, end_date, [holidays])

start_date – The start date.

end_date – The end date.

holidays – [optional] A list of one or more dates that should be considered non-work days

#### Example of NETWORKDAYS Function in Excel

##### Formula

• 23 working days (excluding weekend) are there between Jan-1-2017 is Feb-1-2017
• 22 working days (excluding weekend) are there between Jan-1-2017 is Dec-1-2017, because of start date less than end date number of working days will have negative value (-22).

So the result will be

#### Example of NETWORKDAYS Function in Excel with holiday list

##### Formula

• 21 working days (excluding weekend) and Excluding Holidays are there between Jan-1-2017 is Feb-1-2017
• 22 working days (excluding weekend) and Excluding Holidays are there between Jan-1-2017 is Dec-1-2017, because of start date less than end date number of working days will have negative value (-22).

So the result will be

##### Result