[SOLVED] Using VBA to create a Networkdays function

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" <Frank@discussions.microsoft.com> wrote in message
news:C7134C6D-935D-44A0-910E-74601AC604C9@microsoft.com...
> 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

Hi Tom

Those are beautiful links. The thursday holiday problem which was discussed on some threads can be answered using these formulae.

one of the threads:
http://excelforum.com/showthread.php?t=373356

Mangesh