NETWORKDAYS Formula

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] )

Parameters Details:

  • 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.

Return

The NETWORKDAYS function returns a numeric value.

NETWORKDAYS Formula Example
NETWORKDAYS Formula Example