That is a very clever way of doing it. Just for completness sake, and so that
everyone may benifit. Do you have another trick to remove certain days
(holidays) from the list while counting ?

--
Hany ElKady
Professional Services Architect
Technology & Service Delivery


"daddylonglegs" wrote:


My preference would be to use Ron's NETWORKDAYS suggestion but if you
don't want to use Analysis ToolPak functions and you don't need to
exclude holidays....

=SUM(INT((WEEKDAY(A1-{1,2,3,4,5})+B1-A1)/7))


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