I think our posts crossed :-)
Bob
"daddylonglegs"
wrote in message
news:daddylonglegs.26numm_1145700602.2883@excelfor um-nospam.com...
I see what you mean, Bob. Perhaps it would be better to use
=SMALL(IF(WEEKDAY(ROW(INDIRECT(A1&":"&A1+B1*5)))={ 4,6},ROW(INDIRECT(A1&":"&A
1+B1*5))),B1)
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=534245