how do I calculate the number of business days between two dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a field in a query that calculates the number of business days between
two dates (that are existing in a table) in a query.
Thanks so much for your help.
 
You need to exclude Saturdays, Sundays and holidays. Sundays are day 1 and
Saturdays are day 7. You need a holiday table to define the dates of
holidays.
 

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

Count Number of business days 1
Business Days 4
Calculate business days 2
Calculate between two dates 3
Compare dates in two seperate records 7
Calculating diff btwn two dates how to count only business days 2
calculate two dates 1
calculating average days 1

Back
Top