NETWORKDAYS formula is used to get the number of work days 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 work days calculation. It can be entered either as a range of cells that contain the holiday dates (ie: E2:E5) or as a list of serial numbers that represent the holiday dates.
The NETWORKDAYS function returns a numeric value.