CAS 6

Business days difference between two dates.

User functions daysdiffbusinessbond and daysdiffbusinessfederal can be used to find the number of days between two valid dates. Negative results indicate days going in reverse. Invalid inputs will return -999999.

Example

daysdiffbusinessbond START_DATE END_DATE

START_DATE    END_DATE  DIFF
.→--------------------------.
↓ .→-------. .→-------. .→. |
| |20210602| |20210602| |0| |
| '~-------' '~-------' '~' |
| .→-------. .→-------. .→. |
| |20210603| |20210602| |1| |
| '~-------' '~-------' '~' |
| .→-------. .→-------. .→. |
| |20210604| |20210602| |2| |
| '~-------' '~-------' '~' |
| .→-------. .→-------. .→. |
| |20210605| |20210602| |2| |
| '~-------' '~-------' '~' |
| .→-------. .→-------. .→. |
| |20210606| |20210602| |2| |
| '~-------' '~-------' '~' |
'∊--------------------------'

CAS 6

Business days difference between two dates.

Example

See U.S. Holiday Calendar Descriptions