Business day calculator
business_daysRead-onlyIdempotent
Works with business (working) days. mode "add": returns the date N business days after start_date (start_date itself is not counted; negative N goes backward; 0 returns start_date, or the next business day if start_date is not one). mode "count": counts business days from start_date to end_date, including both ends. Weekends default to Saturday and Sunday. Public holidays are NOT built in — pass them in "holidays".
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| days | No | Business days to add (mode "add") | |
| mode | Yes | "add" or "count" | |
| weekend | No | Weekend days as ISO weekday numbers (1=Monday ... 7=Sunday). Default [6, 7]. Example for Friday-Saturday weekends: [5, 6] | |
| end_date | No | YYYY-MM-DD (mode "count") | |
| holidays | No | Dates (YYYY-MM-DD) to treat as non-working days | |
| start_date | Yes | YYYY-MM-DD |