using "networkdays" formula in access.

[genedi]

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

 

[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