DateDiff to calculate work days

[JeffH]

I'm using the DateDiff function to attempt to calculate the number of working
days between two dates. Unfortunately there does not look to be an interval
variable with this function to calculate the difference solely on working
days. I thought "w" would work based upon the Help information in Access,
but it does not seem to work.

Is there a function I can use to calculate the number of working days
between two dates?

 

[Jeff Boyce]

Jeff

While there are several examples of "working days only" calculating
functions, you do realize, don't you, that you'll need to define which days
are NOT working days. Some countries (and some jurisdictions) celebrate
different holidays (?non-working day?).

Try searching on-line and/or at mvps.org/access for "Workday".

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Al Campagna]

Jeff,
In addition to Jeff Boyce's good advice...
On my website below, I have a sample 97 and 2003 file (Calculate No. of
workdays) that may be helpful.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."