QS.CALENDAR.ADJUST¶
Adjusts an ISO date using a market or joint calendar
Category: QuantSupport - Time.
- QS.CALENDAR.ADJUST(date: text, calendar: text, convention: text) text¶
- Parameters:
date (text) – ISO date text in YYYY-MM-DD format
calendar (text) – Canonical calendar, e.g. Canada(Settlement), Switzerland, China(IB), or JointCalendar(JoinHolidays,TARGET,Japan)
convention (text) – Business-day convention: Following, ModifiedFollowing, Preceding, ModifiedPreceding, or Unadjusted
- Returns:
Business-day-adjusted date as ISO text (YYYY-MM-DD).
- Return Type:
text
- Errors:
#VALUE! if the ISO date, calendar, or business-day convention cannot be parsed.
Formula¶
=QS.CALENDAR.ADJUST(date, calendar, convention)
Calculation¶
Thread-safe worksheet function.
Native Declaration¶
fn qs_calendar_adjust (date : & str , calendar : & str , convention : & str ,) -> Result < String , XllError >