NETWORKDAYS formula is used to get the number of workdays between two dates. It excludes weekends and holidays.
Syntax for NETWORKDAYS formula
NETWORKDAYS( start_date, end_date, [holidays] )
- start_date : The start date to use in the calculation and should be entered as a serial date, not a text date.
- end_date : The end date to use in the calculation and should be entered as a serial date, not a text date.
- holidays: Optional. It is the list of holidays to exclude from the workday’s calculation. It can be entered either as a range of cells that contain the holiday dates (i.e. E2:E5) or as a list of serial numbers that represent the holiday dates.
The NETWORKDAYS function returns a numeric value.