Add business days
add_business_daysRead-onlyIdempotent
Move a number of U.S. business days forward or backward from a date, skipping weekends and observed federal holidays, for due dates, delivery windows and notice periods. The start date is not counted: 1 business day after a Friday is the next Monday, or Tuesday when that Monday is a holiday. Returns the resulting date and every holiday it skipped. Up to 1,000 business days either way.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| start_date | Yes | The date to count from. It is not counted itself, written YYYY-MM-DD (for example 2026-11-26). Covers 2021 through 2100. | |
| business_days | Yes | Business days to move, -1000 to 1000. Negative counts backward. 0 returns the start date if it is a business day, otherwise the next one. |