One thought: Create a list of the days in the year. In the column to the
right of the list code holidays and weekends "Invalid" or some other marker.
Then use COUNTIF to count the number of VALID days between the two days.

As for the Analysis Toolpak causing "system instability"--do your IT guys
realize that it's MSFT-provided software?

Dave
--
Brevity is the soul of wit.


"Duncs" wrote:

For one reason or another, which no one can seem to answer, we cannot
access the "Analysis Toolpak" addin. It isn't there to install, and
our systems guys refuse to run the setup program to make it available
due to, "a possibility of possible system instability", or some such
garbage reason! I've argued until I'm blue in the face, but it makes
no difference. They wont install it.

So, my next mission is to see if I can write one, or if someone else
has written one. I need it for a spreadsheet I'm creating, and can't
think of a way round it.

So, if anyone has any ideas / suggestions / hints / tips / pointers /
code lying around that would help me, I'd be grateful.

Many thanks

Duncs