If Holidays will be involved...try this:

With a list of holidays in cells J1:J5
C1: =SUMPRODUCT((WEEKDAY(ROW(INDEX(A:A,A1):INDEX(A:A,B 1)),2)<6)*ISNA(MATCH(ROW(INDEX(A:A,A1):INDEX(A:A,B 1)),$J$1:$J$5,0)))

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"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