View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
MJW[_2_] MJW[_2_] is offline
external usenet poster
 
Posts: 39
Default DAYS BETWEEN DATES

Not a problem, Danny. But Ron did bring up a salient point--my solution will
only work if you have the analysis pack added on. If you *don't*, you may
want to take a moment to add it, it's well worth it. It can be added via
Tools--Add-In's, and check the box for Data Analysis' related add-in's, if I
recall correctly.

Jamie W.

"Danny C" wrote:

Thanks Ron & MJW
I will be giving both of these a try.
This will help out a lot in determining the "days to grad" I have to use for
my students.

"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