Weekdays in access

[Pete]

I am trying to add 7 business days to a entered date. I
can add days no problem but they are calenday not weekdays
(workdays)

any ideas

 

[Douglas J. Steele]

Check the Date/Time section of "The Access Web" http://www.mvps.org/access/

 

[Doug Munich]

Basically you want to add 9 days (because you'll always go over a weekend),
then if you started on a Thursday or a Friday add two more days (because you
crossed a second weekend).

Doug