Thanks Ros - I think I've solved it in another (less sophisticated!) way.

"Ron Rosenfeld" wrote in message
...
On Mon, 9 Jan 2006 23:40:43 -0000, "Terry Bennett"

wrote:

Thanks for the suggestion.

My own (modern) laptop has this add-in but as the spreadsheet will be used
by a number of people running Excel 95, I wonder whether it will be
available?


NETWORKDAYS was available at least as far back as Excel 4.0 (1992) (in the
Analysis Tool Pak, then, too). It's listed in documentation I have from
that
release. So I'm sure it would have been available in Excel 95.

Is it a problem for them to use the Microsoft supplied add-in? If so,
there
have been formula solutions posted in these NG's that I'm sure can be
located
with a search.


--ron