NETWORKDAYS in a distributed file
 

If it isn't even installed (a distinct possibility) then no.

You would need to write your own function.

--
Regards,
Tom Ogilvy

Tim Childs wrote in message
...
Hi

if I want to use the NETWORKDAYS function in a spreadsheet
that will be sent to colleagues and forwarded by them
elsewhere is there a bulletproof* way of getting round the
problem of the end user not having the Analysis Toolpak
installed? i.e. I want the function to work
without "people having to mess around with the add-in
manager" - many of them will never have used it (even if
they should have <g)

THANKS

Tim

* e.g. creating the function in VB in the workbook's
modules etc

NETWORKDAYS in a distributed file
 

Hi Tom

Thanks for response

I previously did a search on google without success -the code is not
available is it?

Regards

Tim

"Tom Ogilvy" wrote in message
...
If it isn't even installed (a distinct possibility) then no.

You would need to write your own function.

--
Regards,
Tom Ogilvy

NETWORKDAYS in a distributed file
 

Not the code in the analysis toolpak.

Chip might have some code that does the calculation.

wouldn't you just get the number of days and divide by 7, then multiply by
5, then adjust for the weekday of the start and enddate and subtract
holidays.

--
Regards,
Tom Ogilvy


Tim Childs wrote in message
...
Hi Tom

Thanks for response

I previously did a search on google without success -the code is not
available is it?

Regards

Tim

"Tom Ogilvy" wrote in message
...
If it isn't even installed (a distinct possibility) then no.

You would need to write your own function.

--
Regards,
Tom Ogilvy

NETWORKDAYS in a distributed file
 

Here is a KB article with a formula approach (doesn't appear to consider
holidays).

http://support.microsoft.com/default...kb;en-us;61575
Formula to Find Number of Weekdays Between Dates

You could decipher the logic and put that into code. Add in some logic to
check holidays.

This doesn't help, but an interesting reference:

http://support.microsoft.com/default...b;en-us;214094
HOW TO: Use Dates and Times in Excel


--
Regards,
Tom Ogilvy


Tim Childs wrote in message
...
Hi Tom

Thanks for response

I previously did a search on google without success -the code is not
available is it?

Regards

Tim

"Tom Ogilvy" wrote in message
...
If it isn't even installed (a distinct possibility) then no.

You would need to write your own function.

--
Regards,
Tom Ogilvy