The NETWORKDAYS function calculates the number of working days between two dates. The function excludes weekends (Saturday and Sunday) and can exclude holidays if you provide a list.

If you have weekends other than Saturday and Sunday, use the NETWORKDAYS.INTL function.

ðŸ’¡ The `start_date`

and `end_date`

are included in the count of days.

Contents

## Syntax

`=NETWORKDAYS(start_date,end_date,[holiday(s)])`

`start_date`

The date at which to start the counting

`end_date`

The date at which to end the counting

`[holiday(s)]`

An optional list of holidays to exclude from the count of days.

## Video Tutorial

## Related Functions

DAYS – Calculate the number of days between two dates.

DATEDIF – Calculate the time between two dates in years, months, or days.

MINUS – Subtract one value from another. You can use dates with the MINUS function.

NETWORKDAYS.INTL – Calculate the number of workdays between two dates. You can modify which days are weekends.

## Errors

`#VALUE!` – An input isnâ€™t a valid date, such as “The other day” or “Yester-yester-day”. Learn how to work with dates in formulas.

## Examples

### Example 1 – Simple Count of Workdays With No Extra Holidays

Let’s start with a straightforward example.

It’s easy to see how this function can save you time. In this example, NETWORKDAYS skips counting the eight weekend days between November 4, 2022 and November 29, 2022.

Looking at a calendar helps us understand what is happening. NETWORKDAYS counted every weekday between the start and end date and excluded the weekends.

### Example 2 – Removing a Holiday from the Workday Count

Now let’s say that we are running a company in the United States where Thanksgiving is holiday. We don’t want to count Thanksgiving as a workday.

As shown in cell `C2`

, we specified `11/24/22`

as a `holiday`

, therefore removing it from the count of workdays.

### Example 3 – Using Days and Times

Be careful when using dates that include time values.

Google Sheets ignores time values from the inputs and, therefore may appear to return an incorrect result. Only seventeen workdays have passed if you consider the times but Sheets ignores the times and returns `18`

.

### Live Examples

Go to this spreadsheet for the examples of the NETWORKDAYS function shown above that you can study and use anywhere you want.

## Notes

Consider using the IMPORTXML function to obtain a list of your local holidays from the web.