Dave,

I did think on that, but it would mean updating it every year to
reflect the new holiday dates, changes in local holidays and of course,
the yearly changes to Easter.

As regards the "system instability" issues, I've pleaded and begged
them to install it, but they are not for shifting. I've explained that
it's suppl;ied by MS and that it will cause no instability problmes,
but they're not for budging.

Duncs

Dave F wrote:
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