Frank,

The Late Frank Kabel wrote nested worksheet functions to replace many of the
functions in the analysis toolpak. These can be found at ****'s Daily Dose
of Excel (BLOG).

http://www.*****-blog.com/archives/2...-addin-part-1/
http://www.*****-blog.com/archives/2...-addin-part-2/
http://www.*****-blog.com/archives/2...-addin-part-3/

Part 2 covers that date/time functions and has nested function to do
networkdays.

--
Regards,
Tom Ogilvy



"Frank" <[email protected]> wrote in message
news:[email protected]...
> Hi is there a way to create a function that works like the worksheet
function
> "Networkdays" without using the worksheet I have been trying to do with
VBA
> without success.
> Frank