Bojan Nikolic: Using and Understanding the QuantLib Addin

[website home] | [BN Algorithms]

qlCalendarAdvance – Advance a date by specified interval


=qlCalendarAdvance(<Calendar>, <Input Date>, <Interval>,
                   <Convention>, <EndOfMonth>)

Calendar to use for determining business days/holidays. For example, “TARGET” (see TARGET Calendar)

<Input Date>

The date that is to be advanced


The interval of time to advance the input date by. E.g. “1D”, “3D”, “1W”, “3M”, etc. This is a Loop parameters.


Convention to use for modifying a date which falls on a holiday. Default value is “Following”


Enforce the End-of-month convention. Default is false.

You can try this QuantLib functionality online at: