Description Computes the number of whole working days between the specified start date and the specified end date.
Syntax NETWORKDAYS (start_date, end_date, [, holidays])
| Argument | Description |
|---|---|
| start_date | First date of the period. |
| end_date | Last date of the period. |
| holidays | Optional. A list containing numbers, a range of cells, or an array constant representing the dates of holidays. |
Remarks Counts both the first and last days if appropriate.
Excludes weekends and any days in the list of holidays.
Useful for computations that are dependent on the actual hours or days worked in a time period.
Examples This function returns 260:
See Also WEEKDAY
