QS.CALENDAR.IS.HOLIDAY¶
Checks whether an ISO date is a holiday in a canonical calendar
Category: QuantSupport - Time.
- QS.CALENDAR.IS.HOLIDAY(date: text, calendar: text) logical¶
- Parameters:
date (text) – ISO date text in YYYY-MM-DD format within 1902-01-01..2198-12-31
calendar (text) – Canonical calendar, e.g. Canada(Settlement), Switzerland, China(IB), or JointCalendar(JoinHolidays,TARGET,Japan)
- Returns:
TRUE if the native calendar considers the date a holiday (the complement of is_business_day); otherwise FALSE.
- Return Type:
logical
- Errors:
#VALUE! for an invalid canonical calendar or ISO date, or a date outside 1902-01-01..2198-12-31.
Formula¶
=QS.CALENDAR.IS.HOLIDAY(date, calendar)
Calculation¶
Thread-safe worksheet function.
Native Declaration¶
fn qs_calendar_is_holiday (date : & str , calendar : & str) -> Result < bool , XllError >