DateDiff to calculate work days

  • Thread starter Thread starter JeffH
  • Start date Start date
J

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

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
 
Back
Top