Signature (Visual Basic / VBA)
Public Function AddBusinessDays( _
ByVal vDate As Variant _
, ByVal vAddBusinessDays As Variant _
) As Variant
Code Example
Weekday#1/15/2102#) = vbSunday
AddBusinessDays(#1/15/2102#, -2) = #1/12/2102# ' Thu.
AddBusinessDays(#1/15/2102#, -1) = #1/13/2102# ' Fri.
AddBusinessDays(#1/15/2102#, 0) = #1/13/2102# ' Fri.
AddBusinessDays(#1/15/2102#, 1) = #1/16/2102# ' Mon.
AddBusinessDays(#1/15/2102#, 5) = #1/20/2102# ' Fri.
Weekday(#1/16/2102#) = vbMonday
AddBusinessDays(#1/16/2102#, -2) = #1/12/2102# ' Thu.
AddBusinessDays(#1/16/2102#, -1) = #1/13/2102# ' Fri.
AddBusinessDays(#1/16/2102#, 0) = #1/16/2102# ' Mon.
AddBusinessDays(#1/16/2102#, 1) = #1/17/2102# ' Tue.
AddBusinessDays(#1/16/2102#, 5) = #1/23/2102# ' Mon.
Parameters
| Parameter | Description |
|---|---|
| vDate | The date to which a number of business days are added. Function returns Null if vDate is Null or cannot be fixed up to a Date. The time component of vDate (if any) is ignored. |
| vAddBusinessDays | The number of business days to be added to vDate. Function returns Null if vDate is Null or cannot be fixed up to a number. vAddBusinessDays can be negative, in which case a number of business days will be subtracted from vDate. vAddBusinessDays is rounded to the nearest integer. |
Notes & Version History
| Special case | If vAddBusinessDays is 0 (zero), and vDate is a weekend day (Saturday or Sunday), then this function will return the previous business day (that would be the same as calling the function with a vAddBusinessDays value of -1). |
| v2.0 BugFix | Corrected a bug with this function so that it will work correctly when vAddBusinessDays is a negative number. |