---
schema_version: "1"
id: 96226963ef1a511ef6ddf36484b7425deaf654fd9ce7346a7143f77cdbcd8168
title: networkdays
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_function_ref_networkdays.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_networkdays.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: bd2bdd3cca675a5598bbb38d29df9ab18c9bf74df532d23449274978af4ad6e9
description: Returns the number of work days between an upper and lower date or time in Salesforce Spiff, excluding weekends and holidays.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# networkdays

Returns the number of work days between an upper and lower date or time in Salesforce Spiff, excluding weekends and holidays.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</td></tr></tbody></table>

## Syntax

```
networkdays(start_date, end_date, list)
```

## Arguments

  
| Argument | Required? | Description |
| --- | --- | --- |
| start\_date | Required | The lower bound of the date range to check. This argument supports any date functions. |
| end\_date | Required | The upper bound of the date range to check. This argument supports any date functions. |
| list | Optional | A list of dates to exclude from the count. Enclose the list in brackets with comma-separated values, such as `[date("2025-01-20"), date("2025-09-19")]`. |

## Example

Return the number of work days between a contract start date and close date for deals closed in the second quarter of 2024. Exclude May 31.

```
=networkdays(DealToAccountContractStartDate, CloseDate, [date("2024-05-31")])
```