qlCalendarAdvance – Advance a date by specified interval

Usage:

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

<Calendar>

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

<Input Date>

The date that is to be advanced

<Interval>

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

<Convention>

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

<EndOfMonth>

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

You can try this QuantLib functionality online at: http://quantpanel.bnikolic.co.uk/Calendar