Do a search and read the previous posts on the topic. This is asked and answered very often. Look for "business days" or "work days".
The following is from a previous post:
Business Days
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.
--
Rick B
"terrikalee" <(E-Mail Removed)> wrote in message news:46F79671-F8D0-42AF-A36C-(E-Mail Removed)...
> Is there an expression or function which would allow me to calculate future
> dates (based on the current date) but exclude weekends and holidays (business
> days)?