It's a good formula, but it falls down if you go for just 2 days say
{2,4}because ROW(INDIRECT("1:"&B1*3)) creates a too small a comparison date
range.
You can allow for it, but it's a bit messy IMO
=SMALL(IF(WEEKDAY(start_date+ROW(INDIRECT("1:"&num _days*(6-COUNT({2,4,6}))))
-1)={2,4,6},start_date+ROW(INDIRECT("1:"&num_days*( 6-COUNT({2,4,6}))))-1),nu
m_days)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"daddylonglegs"
wrote in message
news:daddylonglegs.26n32y_1145664902.5454@excelfor um-nospam.com...
If start date is in A1 and positive number of business days in B1
=SMALL(IF(WEEKDAY(A1+ROW(INDIRECT("1:"&B1*3))-1)={2,4,6},A1+ROW(INDIRECT("1:
"&B1*3))-1),B1)
confirmed with CTRL+SHIFT+ENTER
note that {2,4,6} refers to Mon, Wed and Fri. Adjust accordingly for
other combinations
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=534245