IBM Lotus Domino Designer 8.5
  Versions 8.5 and 8.5.1

@BusinessDays

Returns the number of business days in one or more date ranges.

Syntax

@BusinessDays( startDates ; endDates ; daysToExclude ; datesToExclude )

Note This @function is new with Release 6.

Parameters

startDates

Time-date or time-date list. The start of each date range.

endDates

Time-date or time-date list. The end of each date range.

daysToExclude

Numer or number list. Optional. Days of the week not counted as business days, where 1 is Sunday and 7 is Saturday. Decimal numbers are rounded to integers. Numbers other than 1-7 are ignored.

datesToExclude

Time-date or time-date list. Optional. Dates not counted as business days.

Return value

numberOfDays

Number or number list. The number of days from startDates to endDates, inclusive, less daysToExclude and datesToExclude that fall within the date range.

Usage

The operation on startDates and endDates is a pair-wise list operation. If they are not the same length, the shorter list is filled out with the value of the last element.

@BusinessDays returns -1 if the calculation produces a negative number of days, an end date precedes a start date, or a time-date value contains only a time.

See examples

---

Library | Support | Terms of use |

Last updated: Monday, October 5, 2009