Networkdays function equivalant

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

I usually use a function called "Networkdays" in Excel
which calculates the working days given a start and end
date. Access 2003 does not recognize this function, is
there an equivalant function in Access that I can use?

Thanks,
Adam
 
Hi,
Have not tried DateDiff. I need this function to work in
the context of a query, and am not familiar with VBA
code. Any way to do this within the query design
interface using expression builder?

Thanks,
Adam
 
Any way to do this within the query design
interface using expression builder?
Click to expand...

Not really. With holidays, as well as weekends, you really need to use
VBA. It's just too complicated!
 
Back
Top