How do I calculate future dates excluding weekends and holidays?

  • Thread starter Thread starter Guest
  • Start date Start date
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)?
 
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.
 
Back
Top