QS.CALENDAR.BUSINESS.DAYS¶
Spills native calendar business days between inclusive ISO date bounds
Category: QuantSupport - Time.
- QS.CALENDAR.BUSINESS.DAYS(from: text, to: text, calendar: text, 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)
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 business-day-list ISO dates (YYYY-MM-DD), ascending with inclusive bounds and no header row. Native WeekendsOnly and NullCalendar return empty lists rather than enumerating dates, even though their business-day predicates may return 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, or from > to. Invalid transpose/headers flags return #VALUE!; use TRUE/FALSE or leave optional flags blank.
Formula¶
=QS.CALENDAR.BUSINESS.DAYS(from, to, calendar, transpose)
Calculation¶
Thread-safe worksheet function.
Native Declaration¶
fn qs_calendar_business_days (from : & str , to : & str , calendar : & str , transpose : * const xll_rs :: types :: XLOPER12 ,) -> Result < * mut xll_rs :: types :: XLOPER12 , XllError >