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