Calculating Leave days

[Stoic]

Hi,
I am working on a project using Access 2010. I have a Leave table with startdate and enddate fields. I have a query to calculate the total days taken. I would like for the query to subtract the Saturdays and Sundays from the leave days if there are.
Can Thanks for your assistance

[Rabbit]

What about holidays?

[Stoic]

My mind is that if I can get the Saturdays and Sundays done, I can as well do the holidays. thanks.

[Seth Schrock]

I had a similar problem, but my issues was more to do with holidays. The solution that I found ended up working for both. Here is the link to the thread: Is there a DateDiff function that counts business days?.