DAYS BETWEEN DATES
With
A1: (startdate)
B1: (enddate)
If you have the Analysis ToolPak add-in installed
=NETWORKDAYS(A1,B1)
or...if you don't....
=SUM(INT((WEEKDAY(A1-{2,3,4,5,6})+B1-A1)/7))
Is that something you can work with?
Post back if you have more questions.
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"Danny C" wrote in message ...
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
|