This function returns the date before or after a specified number of work days
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 Omitted | Saturday, Sunday |
| 2 | Sunday, Monday |
| 3 | Monday, Tuesday |
| 4 | Tuesday, Wednesday |
| 5 | Wednesday, Thursday |
| 6 | Thursday, Friday |
| 7 | Friday, Saturday |
| 11 | Sunday only |
| 12 | Monday only |
| 13 | Tuesday only |
| 14 | Wednesday only |
| 15 | Thursday only |
| 16 | Friday only |
| 17 | Saturday only |
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". |