NETWORKDAYS
Use the NETWORKDAYS function to return the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays.
Use
NETWORKDAYS( start_date, end_date [, holidays] )
Returns the number of whole workdays between two dates.
| Parameter | Required | Description |
|---|---|---|
| start_date | Yes | a date that represents the start date |
| end_date | Yes | a date that represents the end date |
| holidays | No | an array of dates to exclude from the working calendar |
| Returns | Number |
Example
This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.
ON THIS PAGE