calculating working days

[Apples76]

Could you please help me out.

i need to be able to calculate the working days between two dates in access.

the code in excel uses the "NetworkDays" but i belive this is not available
in access. is there a way round it or a way to call that function?

 

[Allen Browne]

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

 

[Keith in KY]

Does the code this article points to get cut and pasted into one module or do
a number of different functions need to be created individually?

 

[Allen Browne]

One standard module (Modules tab of the Database window) is fine.