DriveWorks Solo 15: WorkDayCustom [send feedback...]

WorkDayCustom

This function returns the date before or after a specified number of work days

Syntax

WORKDAYCUSTOM([Date],[Days],[Weekend],[Holidays])

Date is the date to return the week number from

Days is the date to return the week number from

Weekend is the date to return the week number from

Holidays is the date to return the week number from

Weekend Value

Weekend Days
1 or OmittedSaturday, Sunday
2Sunday, Monday
3Monday, Tuesday
4Tuesday, Wednesday
5Wednesday, Thursday
6Thursday, Friday
7Friday, Saturday
11Sunday only
12Monday only
13Tuesday only
14Wednesday only
15Thursday only
16Friday only
17Saturday only

Examples

Rule

Meaning
WORKDAYCUSTOM(Today(),10,1,"10/27/2010")If this function is called on the 19th October 2010 then it would return the value: "03/11/2010".

Table of Contents