Skip to main content
Date Functions

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 )

This article applies to:

  • Product: Contract Express

Related Content