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

M

Mariana

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.
 
P

PC Datasheet

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.
 
Top