BusinessDate() function

BusinessDate() function

BusinessDate(argument list…)

This function adjusts a date according to several business date conventions. The function uses the following arguments:

Argument	Description	Restrictions
Date	starting date	valid Excel date number
Holidays	array of holiday dates	strictly ascending order. If no holiday calendar is available, set to 0.
Convention	business date convention used to adjust the date	0 = no adjustment 1 = Following business day 2 = Modified following business day 3 = Previous business day 4 = End-of-month 5 = End-of-month following 6 = End-of-month previous 7 = Mod. Following with no holidays