How do I keep Access from returning a Saturday/Sunday?

[averyquestion]

I am trying to write a function within Access to add a number of days to the
current date. However, I want the returned date to only be a weekday; never
a weekend date.

 

[Rick B]

Do a search. Date math using business days is a very common topic. Read
the previous posts.

 

[Rick B]

FYI, I also had the following pasted in my personal "helpful hints"
document...

Arvin Meyer has some code on his site you might find useful:
http://www.datastrat.com/ and go to Downloads>CodeDownloads :
GetBusinessDay.

A very straightforward function where you supply today's date and how many
Bdays in the future/past you want returned. It requires a "Holidays" table.

 

[averyquestion]

Rick,

Thanks for your help. My logic in understanding the "weekday" function was
flawed. Thanks for the quick follow-up.