My mistake, i found out my error.


the formula works with the OR value taken out


=IF($A1*$B1=0,"",NETWORKDAYS($A1,$B1))


--
DKerr
------------------------------------------------------------------------
DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087
View this thread: http://www.excelforum.com/showthread...hreadid=471402