Shifts a date forward or backward n business days, adjusting for holidays in the given Centre(s).

Syntax:
AddBusDays(StartDate, NumberOfDays, {Centre(s)|Currency(s)})

StartDate is the date to which days will be added or subtracted.

NumberOfDays is the number of days to shift the date. If NumberOfDays is positive, the date is shifted forwards, if negative the date is shifted backwards.

{Centre(s)|Currency(s)} is the one or more financial centres or currencies which the function should take into account when checking for bank holidays. If more than one centre or currency is to be specified, separate the centres/currencies with a comma. If a currency is specified, the default centre from the iLib control file for that currency is used.

Example:

=AddBusDays(date(2007,6,1),-5,"lon,ny")

Back