Calculating Dates

[burnspaul]

I need to input a date into one field and have access show me a
another date (plus 20 days) in another field (which I can do) but
here
is where I need help. I need to exclude Saturdays & Sundays and Bank
Holidays. Can anyone one help please

 

[Douglas J. Steele]

Take a look in the Date/Time section of "The Access Web"
http://www.mvps.org/access/ There are a couple of possibilities there. You
could also take a look at 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