QS.DATE.ADVANCE¶
Advances an ISO date by a number of Days, Weeks, Months, or Years
Category: QuantSupport - Time.
- QS.DATE.ADVANCE(date: text, length: integer, unit: text) text¶
- Parameters:
date (text) – ISO date text in YYYY-MM-DD format
length (integer) – Whole-number tenor length
unit (text) – Tenor unit: Days, Weeks, Months, or Years
- Returns:
ISO date text (YYYY-MM-DD) advanced by the requested period, without business-day adjustment.
- Return Type:
text
- Errors:
#VALUE! if the ISO date or time unit cannot be parsed.
Formula¶
=QS.DATE.ADVANCE(date, length, unit)
Calculation¶
Thread-safe worksheet function.
Native Declaration¶
fn qs_date_advance (date : & str , length : i32 , unit : & str) -> Result < String , XllError >