Calculating the number of days between dates.

[mkranz]

On a form how would I calculate the number of working days between a range of dates that doesn't count Saturdays, Sundays, or holidays for example: from Septemer 1, 2002 to September 7, 2002. The answer I want Access to return would be 4 working days. I know Excel can do it like this:

=NETWORKDAYS(startdate,enddate,startdate:startdate)

How can I get Access to do the same thing?

 

[Rich]

Article ID: Q149127
Or search here for Holidays or Weekends, there have been numerous posts on the subject

 

[mkranz]

Hello Rich;
Thank you for responding so quickly, but I'm not sure how to apply your suggestion (Q149127) to as a calculated field on a form or report. What I need to know is the elapsed number of days from when a customer places an order and when it ships; less weekends and holidays. Perhaps you could provide me with more detailed directons or sources? Thank you agian.

 

[ColinEssex]

Try this site. It has some good downloads of date calculations including the one you need.

www.mvps.org/access/resources/downloads

Col

 

[Rich]

And this article is more definitive
Article ID: Q97757

The control source would be =Work_Days([StartDate],[EndDate])