using "networkdays" formula in access.

G

Guest

Is there a substitue for the Excel formula "networkdays" in access. I have
seen other posts with this question and the answer seems very confusing or
using VBA.

Can i not just use =networkdays([start date], [completion date], "holiday
range")?

just trying to calculate number of working days between two dates excluding
holidays i have identified in a table.

Thanks Gene
 
D

Douglas J. Steele

Access doesn't actually have the NetWorkDays function in it, and while it's
possible to invoke it from Excel, that would be very inefficient.

Take a look in the Date/Time section of "The Access Web"
http://www.mvps.org/access/ There are a couple of different solutions there.

You could also look at my September, 2004 "Access Answers" column in
Pinnacle Publication's "Smart Access". You can download the column (and
sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html
 

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

networkdays does not work in excel when file opened through Access 2
NetworkDays 3
networkdays alternative 2
networkdays formula in MS access. 1
NETWORKDAYS 3
Networkdays including Saturday? 5
returning a date 7 business day excluding holidays in the future 2
Can't get NETWORKDAYS to calc elapsed banking days in a month 2

Top