How to calculate # of work days inconjunction with datediff in Ac.

[Guest]

I can write script to do this but was wondering is there is a built-in
function that can be used in Queries to get the number of work days
(excluding weekends) returned from the difference in two dates. A similar
function is the NETWORKDAYS in Excel...

 

[Rick B]

Asked and answered ALL the time. Did you do a search before posting this?

Rick B

 

[Michel Walsh]

Hi,


You can take a look at http://www.mvps.org/access/datetime/date0012.htm.
There are some VBA code you can paste, in a module, and then, after, use
them in your query (or elsewhere).



Hoping it may help,
Vanderghast, Access MVP