Working days

[Elton]

Hi there:

Is there any function for the calculation of no. of
working days between 2 dates in Query?

Thanks,
Elton

 

[LRien]

Elton,

I have found the "NETWORKDAYS" function that calculates
the number of whole working days between a start and end
date.

I am trying to use it in a Query and am having difficulty
getting it to run. I get the message "function not
found..."

If anyone know how to utilize this function in a Query, I
too am very interested in its usage.

Thanks!
Linda

 

[John Spencer (MVP)]

Try the function at the following URL
http://www.mvps.org/access/datetime/date0006.htm

or for a more complex function handling holidays also
http://www.mvps.org/access/datetime/date0012.htm