WTF? This is a family group Mike <vbg

BTW, the problem with long formulae applies to any function, it is an Excel
restriction, whereby you can only have 7 nested functions, and/or 255
characters entered (you can frig more, but only enter 255), at least until
Office 12.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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

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.

I spose it does help if you understand wtf the formula is doing. :-)

Thanks for clarifying, Roger.
R.