find number of work days, excluding holidays

[Guest]

I need a way to calculate the number of workdays, minus holidays in an access
database. Excel has the NETWORKDAYS worksheet function, but cannot use it in
access

 

[Allen Browne]

See:
Doing WorkDay Math in VBA
at:
http://www.mvps.org/access/datetime/date0012.htm

 

[Guest]

I get a comile error that says user defined type not defined on a line that
says DIM DB as DAO.Database. What is the fix for this? I got this procedure
from the website you directed me to.

 

[Douglas J. Steele]

With any code module open, select Tools | References from the menu bar.
Scroll down through the list of available references until you find
Microsoft DAO 3.6 Object Library and put a checkmark beside it.