If you want calendar days over.....

With available date in A1 and returned date in B1

either

=B1-WORKDAY(A1,4)

custom format cell as 0;;

or without formatting

=IF(B1WORKDAY(A1,4),B1-WORKDAY(A1,4),"")


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