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.

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

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.

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

numberOfDays

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

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.

Example
See Also

Performing time-date operations

Glossary