BusinessDate() function  Previous topicNext topicFirst topicLast topic

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 bus
iness day
4 = End-of-month
5 = End-of-month following
6 = End-of-month previous
7 = Mod. Followin
g with no holidays

© 1995-98 Leap of Faith Research Inc.