View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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