NETWORKDAYS.INTL (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

Syntax

NETWORKDAYS.INTL(start date, end date, OPTIONAL weekend, 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

weekend

A number or string that specifies when weekends occur. Weekend days are days of the week that are not included in the number of whole working days between startdate and enddate

StringOrNumber

Y

holidays

Range of dates to exclude from the calculation. Holidays can be a range of cells that contain the dates, or an array constant of the serial values that represent those dates

StringOrNumber

Y

Comments

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