Sorry typo in the above, 5 at the end should be 6, i.e.

=SUM(INT((WEEKDAY(A1-{2,3,4,5,6})+B1-A1)/7))-SUMPRODUCT(--(holidays=A1),--(holidays<=B1),--(WEEKDAY(holidays,2)<6))

"daddylonglegs" wrote:

If you want to exclude holidays too you can extend Ron C's suggestion above,
i.e.

=SUM(INT((WEEKDAY(A1-{2,3,4,5,6})+B1-A1)/7))-SUMPRODUCT(--(holidays=A1),--(holidays<=B1),--(WEEKDAY(holidays,2)<5))

where holidays is a named range containing your holiday dates



"Danny C" wrote:

Thanks for the reply, however when doing so there is nothing in the Add Ins
Dialog box (completely blank). So it probably was not loaded on install
(before I got here).

Thanks again
Danny

"David Biddulph" wrote:

In a default installation the Analysis ToolPak will have been installed on
your machine but not enabled, so it should be easy to enable NETWORKDAYS.
Try Tools/ AddIns, and select Analysis ToolPak.
--
David Biddulph

"Danny C" wrote in message
...
THANKS FOR THE TIPS

I can't use the NETWORKDAYS funtion (don't have it) but the other one
=SUM(INT((WEEKDAY(A1-{2,3,4,5,6})+B1-A1)/7))
Seems to work just fine. It doesn't do Holidays, so I'll have to check
out
the rest of the posts.

Danny

"Danny C" wrote:

How do you calculate days between dates BUT not count the SAT & SUN in
that
range?

I know you have to change everything to days of the week, but how do you
delete (or not count) SAT & SUN's