I'm not sure what you're trying to do here. Why can't you just copy the
formula down to the maximum number of rows you may need?

If you just want to keep E2 blank if there are no dates in C2 and D2
perhaps

=IF(D2*C2,-IF(D2=C2,NETWORKDAYS(D2,C2)-1,NETWORKDAYS(D2,C2)+1),"")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=567098