NETWORKDAYS (PQL - xl)

This function returns the total number of complete working days between the start and end dates

  • Library: PQL \ Spreadsheet \ Date & Time
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
  • Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions

Syntax

NETWORKDAYS(start date, end date, OPTIONAL holidays)

Function Arguments

Name

Description

Type

Optional

start date

Date that is the starting date; a number (as in 37806.5), or a DateTime object, as in DATE(2003,7,4)

StringOrNumber

end date

Date that is the ending date; a number (as in 37806.5), or a DateTime object, as in DATE(2003,7,4)

StringOrNumber

holidays

Range of dates to exclude from the calculation; if omitted, the calculation assumes no holidays and all weekdays are workdays

StringOrNumber

Y

Comments

This function is the same as the Microsoft Excel 'NETWORKDAYS' function - using the same inputs, logic and outputs.