---
url: /cube-functions/networkdays.md
description: >-
  Calculates the number of working days between two dates, excluding weekends
  and holidays.
---

# NETWORKDAYS 

Calculates the number of working days between two dates, excluding weekends and holidays.

```js
NETWORKDAYS(start_date, end_date, ...holiday_n)
```

#### Parameters

* `start_date` - The start date, represented as an Excel date value.
* `end_date` - The end date, represented as an Excel date value.
* `holiday_n` - A date value, represented as an Excel date value. If omitted, no holidays are excluded. `(optional)`

#### Examples

```js
NETWORKDAYS(44197, 44300)

```

**Result:** `74`

**Note:** Calculates the number of working days between the start date (2021-01-01) and the end date (2021-04-14), excluding weekends (Saturday and Sunday).

```js
NETWORKDAYS("2022-04-01", "2022-04-30", "2022-04-05", "2022-04-15")

```

**Result:** `19`

**Note:** Calculates the number of working days between the start date (2022-04-01) and the end date (2022-04-30), excluding weekends (Saturday and Sunday) and the specified holidays (April 5 and 15, 2022).