Calculates the work date that is before or after a start date, as specified by a number of days. A set of holiday dates can be optionally specified.

workday(StartDate, 4)

Output: Returns the date that is four working days after StartDate.

workday(date1,numDays,[array_holiday])


ArgumentRequired?Data TypeDescription
date1YdatetimeStarting date to compare
numDaysYintegerNumber of days before or after starting date
array_holidayNarrayAn array of string values representing the valid dates of holidays

date1

Date value can be column references or output of the DATE function or the TIME function.


Required?Data TypeExample Value
YesDatetime (Column reference or date output of DATE or TIME function)LastContactDate

numDays

An Integer that defines the number of working days distance from the start date. The function returns the start date plus or minus the number of working days represented in this Integer.

If the integer is less than zero, the number of working days are counted backward from the start date.

Required?Data TypeExample Value
Yesinteger10

array_holiday

An array containing the list of holidays, which are factored in the calculation of working days.

Values in the array must be in either of the following formats:

['2020-12-24','2020-12-25']
['2020/12/24','2020/12/25']


Required?Data TypeExample Value
YesArray['2018-12,24','2018-12-25','2018-12-31','2019-01-01']

Example - Date diffing functions