Working Days

[BilboBaggins]

Hi all
I am trying to calculate the number of working days
between two variable dates in a query. I have tried the
Excel Networkdays function but it does not recognise it.
I have checked and I have MSOWCF.DLL installed in the
references as it recommends. Is there another way of
doing this or am I likely to be doing something wrong?

 

[Michel Walsh]

Hi,


Take a look at http://www.mvps.org/access/datetime/date0012.htm, in
particular, to dhCountWorkdaysA( )



Hoping it may help,
Vanderghast, Access MVP