Count business days
count_business_daysRead-onlyIdempotent
Count the U.S. business days between two dates, both dates included, leaving out weekends and observed federal holidays. Returns the business day count, the weekend days, and each holiday that fell in the span. Spans up to 3,660 calendar days.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end_date | Yes | Last date of the span, counted if it is a business day, written YYYY-MM-DD (for example 2026-11-26). Covers 2021 through 2100. | |
| start_date | Yes | First date of the span, counted if it is a business day, written YYYY-MM-DD (for example 2026-11-26). Covers 2021 through 2100. |