Calculate working days

[Linajkl]

I have a query, how can I calculate the working days between two dates without taking into account Saturdays, Sundays and holidays.


I appreciate the detailed help. I´m beginer
beginnerbeginbeginnerbeginnerbeginnerbeginnerbeI have a query, how can I calculate the working days between two dates without taking into account Saturdays, Sundays and holidays

[pbaldy]

Typically done with a custom function. Searching on your title should return results, plus there's the "similar threads" section under your thread. Here's one of many:

http://access.mvps.org/access/datetime/date0006.htm

http://access.mvps.org/access/datetime/date0012.htm

[orange]

You may find this thread helpful. Not sure what "working days" means when you say

without taking into account Saturdays, Sundays and holidays

.