calculate_business_days
Calculate business days between dates or add/subtract business days from a date, excluding weekends and optional public holidays.
Instructions
Calculate business days between two dates or add/subtract business days from a date. Skips weekends and optionally public holidays.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | Yes | 'count': count business days between from and to. 'add': add N business days to from date. | |
| from | Yes | Start date in YYYY-MM-DD format | |
| to | No | End date in YYYY-MM-DD format (required for 'count' action) | |
| business_days | No | Number of business days to add (required for 'add' action, negative to subtract) | |
| country | No | Country code for public holidays (e.g. CN, US). If omitted, only weekends are skipped. | |
| timezone | No | IANA timezone. Defaults to UTC. |