Calculate a business-day due date and SLA
add_business_daysUse this when the user asks what date is a number of working days, business days or workdays after or before a date, including an SLA due date or turnaround, for example "what date is 37 business days after 11 August in England?", "when is payment due 30 business days from invoice date 3 March in Germany?" or "5 working days before 20 December in the US". Pass the country code, the start date as YYYY-MM-DD, the number of days (negative for earlier) and a region when the user names one. The start date is day 0 and is not counted. Returns the resulting date and weekday, the holidays skipped, and the conventions used. At most 1000 business days. For a trade's settlement date (T+1, T+2) pass calendars, such as ["NYSE", "FED"], ["LSE"] or ["JPX"]. Do not use it for legal deadlines that follow their own court or contract rules, or for calendar-day offsets.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| days | Yes | Working days to move: positive for later, negative for earlier. At most 1000 either way. | |
| region | No | State, province or nation within the country, as a subdivision code such as DE-BY or BY (Bavaria), GB-SCT (Scotland), US-CA or AU-NSW. Optional. | |
| country | Yes | Two-letter ISO 3166-1 country code whose holidays apply, such as US, GB, DE, AU or VN. | |
| calendars | No | Holiday calendars to apply; a day is off when any of them closes it. "public" (the default) is the country's public holidays. NYSE is the New York Stock Exchange (also Nasdaq), FED the Federal Reserve and Fedwire (which DTC settlement follows), LSE the London Stock Exchange, JPX the Japan Exchange Group, TARGET2 the euro payment system. For a settlement date join the market and payment calendars, such as ["NYSE", "FED"] for a US T+1 settlement or ["TARGET2", "FED"] for EUR/USD spot. Optional. | |
| startDate | Yes | The date to count from, YYYY-MM-DD. It is day 0 and is not counted. | |
| weekendDays | No | Days of the week that are not working days. Default: saturday and sunday. Use friday and saturday where that is the weekend. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| days | Yes | ||
| note | No | ||
| region | No | ||
| source | Yes | ||
| country | Yes | ||
| weekend | No | ||
| calendars | No | The calendars applied, when the call named calendars | |
| startDate | Yes | ||
| resultDate | Yes | ||
| conventions | Yes | ||
| calendarDays | Yes | ||
| resultWeekday | Yes | ||
| holidaysSkipped | Yes | ||
| startIsBusinessDay | Yes |