QS.CALENDAR.HOLIDAYS¶
Spills native calendar holidays between inclusive ISO date bounds
Category: QuantSupport - Time.
- QS.CALENDAR.HOLIDAYS(from: text, to: text, calendar: text, include_weekends: cell or range, transpose: logical or blank) spilled range¶
- Parameters:
from (text) – Inclusive ISO date bound in YYYY-MM-DD format within 1902-01-01..2198-12-31; from must be <= to
to (text) – Inclusive ISO date bound in YYYY-MM-DD format within 1902-01-01..2198-12-31; from must be <= to
calendar (text) – Canonical calendar, e.g. Canada(Settlement), Switzerland, China(IB), or JointCalendar(JoinHolidays,TARGET,Japan)
include_weekends (cell or range) – Optional TRUE/FALSE or numeric flag (nonzero is TRUE) including weekend holidays; omitted or blank defaults to FALSE; WeekendsOnly still returns an empty native list
transpose (logical or blank) – Optional TRUE transposes the entire spill; omitted or blank defaults to FALSE; table headers move with their fields
- Returns:
One-column spill of native holiday-list ISO dates (YYYY-MM-DD), ascending with inclusive bounds and no header row; weekends are excluded by default. Native WeekendsOnly and NullCalendar return empty lists even when include_weekends is TRUE. transpose=TRUE exchanges rows and columns; omitted transpose defaults to FALSE. Empty output returns a blank cell.
- Return Type:
spilled range
- Errors:
#VALUE! for an invalid canonical calendar or ISO date, a date outside 1902-01-01..2198-12-31, from > to, or a non-boolean/nonnumeric include_weekends flag. Invalid transpose/headers flags return #VALUE!; use TRUE/FALSE or leave optional flags blank.
Formula¶
=QS.CALENDAR.HOLIDAYS(from, to, calendar, include_weekends, transpose)
Calculation¶
Thread-safe worksheet function.
Native Declaration¶
fn qs_calendar_holidays (from : & str , to : & str , calendar : & str , include_weekends : * const xll_rs :: types :: XLOPER12 , transpose : * const xll_rs :: types :: XLOPER12 ,) -> Result < * mut xll_rs :: types :: XLOPER12 , XllError >