QS.SCHEDULE¶
Spills an unadjusted schedule between two ISO dates
Category: QuantSupport - Time.
- QS.SCHEDULE(start_date: text, end_date: text, frequency: text, transpose: logical or blank) spilled range¶
- Parameters:
start_date (text) – ISO date text in YYYY-MM-DD format
end_date (text) – ISO date text in YYYY-MM-DD format
frequency (text) – Required frequency such as Annual, Semiannual, Quarterly, Monthly, or NoFrequency; no blank-input default
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 unadjusted schedule dates as ISO text (YYYY-MM-DD), without a header row. transpose=TRUE exchanges rows and columns; omitted transpose defaults to FALSE. Empty output returns a blank cell.
- Return Type:
spilled range
- Errors:
#VALUE! for invalid dates/frequency or a schedule-builder failure. Invalid transpose/headers flags return #VALUE!; use TRUE/FALSE or leave optional flags blank.
Formula¶
=QS.SCHEDULE(start_date, end_date, frequency, transpose)
Calculation¶
Thread-safe worksheet function.
Native Declaration¶
fn qs_schedule (start_date : & str , end_date : & str , frequency : & str , transpose : * const xll_rs :: types :: XLOPER12 ,) -> Result < * mut xll_rs :: types :: XLOPER12 , XllError >