Networkday Function

[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

 

[mlindsay]

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.

 

[Dirk Goldgar]

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?

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.