Networkday Function

  • Thread starter Thread starter Trish
  • Start date Start date
T

Trish

Has anyone got this function to work? I've tried and
tried and I always get "Undefined Function". I've
researched this on the Web and it appears that every
replies to this question with a module or coding?

Thanks
 
Excel has a Networkdays() function in one of the "Analysis" Add-ins and it
works fine there. I have not seen it in Access or tried using Excel's
version from Access.
 
Trish said:
Has anyone got this function to work? I've tried and
tried and I always get "Undefined Function". I've
researched this on the Web and it appears that every
replies to this question with a module or coding?
Click to expand...

Although it shows up in the Access 2000/2002 online help for some
obscure reason, it's an Excel function, not an Access function, and
can't be used unless you set a reference to Excel and create an Excel
application object. I would not go to all that trouble and overhead for
this purpose. Instead, I'd use one of the many user-defined functions
you'll have seen posted for the purpose.
 
Back
Top