How do I calculate future dates excluding weekends and holidays?

G

Guest

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)?
 
R

Rick B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DateDiff exclude weekends and holidays 6
Number of days between two dates excluding Holidays and weekends. 4
How to calculate today's date plus 10 business dates? 1
Steele's Diff2Dates Function without Holidays & Weekends 4
Calculate days help 2
Calculate work days 3
Access Functions 1
Calculate a future date excluding weekends and holidays 4

Top