"daddylonglegs"
wrote in message
news:daddylonglegs.271lrm_1146342302.402@excelforu m-nospam.com...

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))={1,2,3,4,7}))

Nicely thought out


--
Regards

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk