Calculates the work date that is before or after a start date, as specified by a number of days. You can also specify which days of the week are working days and a list of holidays via parameters.

workdayintl(StartDate, 5,'0000001')

Output: Returns the working date that is five days after the StartDate, assuming that every day except for Sunday is a working day.


ArgumentRequired?Data TypeDescription
date1YdatetimeStarting date to compare
numDaysYintegerNumber of days before or after starting date

Seven-character string identifying the weekend days.

array_holidayNarrayAn array of string values representing the valid dates of holidays.


Date value can be a column reference 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


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


A seven-character string identifying the days of the week that are working days.


str_workingdaysWeekend days
'0000011'Saturday and Sunday (default)
'1000011'Monday, Saturday, and Sunday

Required?Data TypeExample Value


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:


Required?Data TypeExample Value

Example - Date diffing functions