Subtract business days using the US federal Market calendar.
Get business days between two valid dates using the US Federal Bank Holiday calendar.
Invalid dates always return -999999.
If Start Date > End Date and Start Date is not a Federal Bank business day, then Start Date moves to the previous Federal business day.
If Start Date < End Date and Start Date is not a Federal Bank business day, then Start Date moves to the next Federal business day.
The Business days difference result includes the End Date but not the Start Date
daysdiffbusinessfederal DATE_FIELD 20210112
daysdiffbusinessfederal DATE_FIELD1 DATE_FIELD2
daysdiffbusinessfederal 20210805 20210804
daysdiffbusinessfederal 20210805 20210804
daysdiffbusinessfederal 20210809 20210806
daysdiffbusinessfederal 20210807 20210731
daysdiffbusinessfederal StartDate EndDate
| Name | Data Type | Input Type | Description | Optional | Default |
|---|---|---|---|---|---|
| StartDate | Date | Field, Constant | Start Date | No | |
| EndDate | Date | Field, Constant | End Date | No |
Type: Integer
Business days difference.