Investment Studio > Expressions > Functions > Date & Time > WORKDAY

date workday(date start_date, integer days, date array holidays = {})

Returns start_date offset by the specifed number of working days. Weekends and any dates contained in the (optional) holidays array do not contribute to the day count.

Automatic type conversion allows the use of a start_date string instead of an explicit date value.

Example

Assuming standard US date format settings,

=workday("2/1/2002", 10)

equals 2/15/2002, while

=workday("2/1/2002", 10, {"2/8/2002", "2/9/2002"})

equals 2/18/2002 (not 2/19/2002 since the last "holiday", 2/9/2002, is a Saturday and thus excluded anyway in both cases).

See also edate, eomonth, networkdays, yearfrac.