QS.CALENDAR.IS.BUSINESS.DAY¶
Checks a date against a market or joint calendar
Category: QuantSupport - Time.
- QS.CALENDAR.IS.BUSINESS.DAY(date: text, calendar: text) logical¶
- Parameters:
date (text) – ISO date text in YYYY-MM-DD format
calendar (text) – Canonical calendar, e.g. Canada(Settlement), Switzerland, China(IB), or JointCalendar(JoinHolidays,TARGET,Japan)
- Returns:
TRUE if the date is a business day in the supplied calendar; otherwise FALSE.
- Return Type:
logical
- Errors:
#VALUE! if the ISO date or calendar cannot be parsed.
Formula¶
=QS.CALENDAR.IS.BUSINESS.DAY(date, calendar)
Calculation¶
Thread-safe worksheet function.
Native Declaration¶
fn qs_calendar_is_business_day (date : & str , calendar : & str) -> Result < bool , XllError >