=if(and(l7<"",r7<""),networkdays(l7,if(count(m7: p7),max(m7:p7),q7)),"")


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=484554