how to calculate 15 working days of a certaing record

[Guest]

VBA Master,
i just want to ask on how to calculate only the 15 working days of a
certaing record (dont mind the holidays only the saturdars and sundays will
be disregard on count).

hope you can help me. many thanks.

pnexs ignus

 

[Douglas J. Steele]

One approach is outlined in http://www.mvps.org/access/datetime/date0012.htm
at "The Access Web".

I showed another way in my September, 2004 "Access Answers" column in
Pinnacle Publication's "Smart Access". You can download the column (and
sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html