I'm starting to come up with a version of DateAdd that I call
BusinessDateAdd that adds the selected number of business days. It's
still in preliminary form (needs testing) and interacts with my direct
date functions (which have also changed slightly). There's no room to
put the code in the margins :-), but there's enough room to put up a
few URL's. The zip file is a zipped A97 mdb file with a single module.
Zipped:
http://www.oakland.edu/~fortune/DirectDateFunctions.zip
Text:
http://www.oakland.edu/~fortune/DirectDateFunctions.txt
Syntax:
BusinessDateAdd(number, date, boolean)
number = number of business days to add
date = starting date
boolean = True when using observed holiday functions
Example:
BusinessDateAdd(10, #12/23/06#, False) =1/9/2007
Sample calculation:
12/23/06 Starting Date
12/24/06 Sunday
12/25/06 Christmas
12/26/06 Tue +1
12/27/06 Wed +1
12/28/06 Thu +1
12/29/06 Fri +1
12/30/06 Saturday
12/31/06 Sunday
1/1/07 New Year's Day
1/2/07 Tue +1
1/3/07 Wed +1
1/4/07 Thu +1
1/5/07 Fri +1
1/6/07 Saturday
1/7/07 Sunday
1/8/07 Mon +1
1/9/07 Tenth business day after 12/23/06
It considers a business day to be a weekday that is not a(n) (observed)
holiday.
James A. Fortune
CD********@FortuneJames.com