# Excel NETWORKDAYS function

## Summary

The Excel NETWORKDAYS function calculates the number of weekdays between two dates, automatically excluding weekends (Saturdays and Sundays). It can also optionally exclude a list of holidays. This function is widely used in business for calculating working days in project planning, employee benefits accrual, or deadline tracking.
##### Syntax
```				```
=NETWORKDAYS(start_date, end_date, [holidays])
```
```
• start_date: The beginning of the date range.
• end_date: The end of the date range.
• holidays: [Optional] A range of dates to be excluded as holidays.
##### Return value
The number of weekdays between the start and end dates.

## How to use

Use NETWORKDAYS to find out how many weekdays are there in a specific period, excluding weekends and optionally excluding specified holidays. This function is especially helpful for HR in calculating leaves, for project managers in scheduling tasks, or for finance in calculating interest over working days.

## Examples

##### Simple NETWORKDAYS
Basic Working Days Calculation: Calculating the number of working days between two dates:
```				```
=NETWORKDAYS("2021-01-01", "2021-01-31")
```
```
This formula calculates the number of weekdays in January 2021.
##### NETWORKDAYS with Holidays
Calculating Working Days Excluding Holidays: Including a range of holidays in the calculation:
```				```
=NETWORKDAYS(start_date, end_date, A1:A5)
```
```
Assuming A1:A5 contains a list of holiday dates, this formula calculates the working days between start_date and end_date, excluding those holidays.
##### NETWORKDAYS for Project Duration
Project Duration in Working Days: Determining the duration of a project in working days:
```				```
=NETWORKDAYS(project_start, project_end)
```
```
This formula gives the number of working days from the start to the end of a project, helping in estimating the time required to complete it.