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

# SNETWORKDAYS 

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

```js
SNETWORKDAYS(start_date, end_date, holidays_comma_delimited)
```

#### Parameters

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

#### Examples

```js
SNETWORKDAYS(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
SNETWORKDAYS("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).