Working days

[Guest]

I am trying to figure out how many days a vehilce is in my shop. If I have
(date in) and (date out), what formula can i use to find out the number of
workign days the vehilce was in the shop.

 

[Allen Browne]

See:
Doing WorkDay Math in VBA
at:
http://www.mvps.org/access/datetime/date0012.htm

 

[Guest]

I found a previous post written by you directing me to this website. Sorry
for not looking in advance.

 

[Arvin Meyer [MVP]]

There are hundreds of pages of code at that site, and at Allen's site. Have
a look at these MVP links:

http://www.accessmvp.com/Links.htm

and these:

http://www.mvps.org/links.html

for most of the code you'll ever want to use.