Hi Bob
I know the feeling!!!<bg

--
Regards

Roger Govier


"Bob Phillips" wrote in message
...
Thanks Roger. I thought I had explained that, but what was clear in my
mind
wasn't necessarily clear on paper <vbg

Bob

(remove nothere from email address if mailing direct)

"Roger Govier" wrote in message
...
Hi Mike

There is no need to worry about the "blocks".
You can use a contiguous range right across the sheet if you want, as
Bob's formula is only counting the 5 weekdays and ignoring the
weekends.
Just change the 2 occurrences of H7 in Bob's formula to the last
column
that has data that you want to consider.

--
Regards

Roger Govier


"Mike Echo" wrote in message
u...
In article ,
says...
Mike,

I am not sure what you are referring to when you say the string
length. Can
you elucidate?

With some formulae you are limited by the length of the formulae
itself
(you can get around this by using named ranges). I can't be sure
but I
think sumproduct was one such formula.

I have many months worth of five day blocks across my sheet.

Thanks,
R.