DateDiff to calculate work days



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


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 for "Workday".


Jeff Boyce
Microsoft Office/Access MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads