AddBusinessDays() function  Previous topicNext topicFirst topicLast topic

AddBusinessDays() function

AddBusinessDays(argument list…)

This function adds/subtracts a user-specified number of business days to/from a start date. The function uses the following arguments:

Argument Description Restrictions
Start_Date Excel date number valid Excel date number
Holidays array of holiday dates strictly ascending order. If no holiday calendar is available, set to 0.
NumDays number of business days to add/subtract to/from Start_Date integer values

© 1995-98 Leap of Faith Research Inc.