Returns the number of work days between an upper and lower date or time in Salesforce Spiff, excluding weekends and holidays.
Required Editions
| Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience |
| Available in: Enterprise, Unlimited, and Developer Editions |
| Available for an additional cost in: Professional Edition with Web Services API Enabled |
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")])