This article applies to:

Workday Function

Description:

The date which is so many working days after the source date.

note

This function is similar to the Excel function WORKDAY.INTL.

Returns:

Date

Parameters:

Parameter	Data Type	Description
1	Date	The source date.
2	Whole Number	The number of whole days after
3	Date*	List of dates that are non-working days. Optional.
4	Whole Number*	List of days of the week that represent non-working days, expressed as numbers from 1 (Sunday) to 7 (Saturday). Optional, if left blank, defaults to List( 1, 7 ).

Examples:

When using functions inside a field, remember the field brackets:

{Workday( StartDate, AddDays )}

{Workday( StartDate, AddDays, Collect(HolidayDate) )}

{Workday( StartDate, AddDays, Collect(HolidayDate), ToInteger(NonWorkingWeekdays) )}

{Workday( StartDate, AddDays, List(), List(2) )}

Expression	Result
Workday( Date( 2020, 12, 1 ), 20, List( Date( 2020, 12, 24 ), Date( 2020, 12, 25 ) ), List( 1 ) )	Date( 2020, 12, 26 )