NETWORKDAYS

Get the number of working days between two dates

Sponsored Link

NETWORKDAYS

Purpose 

Get the number of working days between two dates

Return value 

A number representing days.

Syntax 

=NETWORKDAYS (start_date, end_date, [holidays])

Arguments 

  • start_date - The start date.
  • end_date - The end date.
  • holidays - [optional] A list of one or more dates that should be considered non-work days.

Usage notes 

Note: Working days exclude weekends and dates supplied as holidays.

NETWORKDAYS can be used to calculate employee benefits that accrue based on days worked, the number of working days available in a certain time range.

If you receive a #NAME? error when trying to use this function, install and load the Analysis ToolPak add-in.

Sponsored Link

0 votes. 0 / 5