workdays()

Read(3765) Label: workdays, between two dates,

Description:

Return a sequence of workdays between two dates inclusive.

Syntax:

workdays(b,e,h)

Note:

The function gets a sequence of workdays between date b and date e inclusive. Members of h are either weekend or holidays. If there is an on-duty shift in a weekend day, take it as the weekday.

Parameter:

b

Date

e

Date

h

A sequence composed of values of date data type

Return value:

Sequence

Example:

 

A

 

1

=workdays(date("2015-04-02"),date("2015-04-08"),[date("2015-04-04"),date("2015-04-05"),date("2015-04-06")])