Just wanted to add my 2 cents: this formula worked for me also, figuring
early and late shipments, where the NETWORKDAYS function kept adding an extra
day. Thank you much.
"Alex Delamain" wrote:
Try this one then
=IF(B8=A8,NETWORKDAYS(A8,B8)-1,NETWORKDAYS(A8,B8)+1)
--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=265428