How do I calculate working days only from between 2 dates?

[Case]

I need to calculate turnaround times between 2 dates and excluding weekends.

 

[Van T. Dinh]

See The Access Web article:

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

 

[Trauton]

Hi,

I just used the function recomended by Van and it worked great. I choose
the 2nd function (where you can set up a table with your company's holidays
to exclude those as well from the count).

One thing you need to keep in mind is that you need to use different names
for the function and the module. The tendency (myself included) is to use
the same name for both, but Access has an issue with that). Of course I also
learned that from Van!

Hope this helps,

Trauton