WORKDAY.INTL (PQL - xl)

This function returns the serial number of the date before or after a specified number of workdays with custom weekend parameters

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

Syntax

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

days

Number of workdays 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

weekend

A number or string that specifies when weekends occur. Weekend days are days of the week that are not counted as working days

StringOrNumber

Y

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