WORKDAY (PQL - xl)

This function returns the number of working days before or after the starting date

  • Library: PQL \ Spreadsheet \ Date & Time
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

WORKDAY(start date, days, 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

days

Number of non-weekend or non-holiday days before or after the starting date; days in the future are positive and days in the past are negative; if not an integer, the number is truncated

Number

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 'WORKDAY' function - using the same inputs, logic and outputs.