workday() Function

Returns the date the given number of workdays before or after the given date.

Syntax

workday( starting date, days, [holidays] )

starting_date: (Date) The starting date.

days: (Integer) The number of days to advance into the future (positive numbers) or days to retreat into the past (negative numbers).

holidays: (Date) A list of holidays not counted as workdays.

Returns

Date

Notes

An array of holidays may be given by enclosing them in braces, such as {"12/25/2004","12/31/2004"}.

Examples

You can experiment with this function in the test box below.

Test Input

workday(date(2011,12,13),-6) returns 12/5/2011

FEEDBACK