Trying to get work days out of two dates

  • Thread starter Thread starter erick-flores
  • Start date Start date
E

erick-flores

Hello all,

This is what I have:
A: 07/22/08
B: 07/29/08

I want to get the result of = A - B in working days. Right now I am
getting 7 as a result but I want to get 5 as a result (not include the
weekends).

Any ideas how to accomplish this?

Thanks in advace.
 
Actually, working days starting 7/22/08 and ending 7/29/08 = 6 (as there are
a total of 8 days from 7/22 to 7/29, including 7/22).
=NETWORKDAYS(startdate,enddate,holidays)
If you are are, for example, trying to say a deadline in 5 working days,
then you could just subtract 1 from the formula above.

holidays is a range of dates that are actual holidays. There is good info in
the MS Help on NETWORKDAYS.
 
I want to get 5 as a result

This requires the Analysis ToolPak add-in be installed if you're using a
version of Excel prior to Excel 2207.

=NETWORKDAYS(A1,B1)-(WEEKDAY(A1,2)<6)
 
Thanks for ur reply.

I am trying the =networkdays() formula, but I am getting the #NAME?
error

What do I need check?

Thanks
 
I tried on MS Excecl 2007 and it worked just fine. I wonder what can
be wrong in MS Excel 2003.

Any ideas???
 
Nothing wrong, you need to go to tools>add-ins, select ATP (Analysis
ToolPak,)
if it was installed when office /excel was installed it will be available,
if not you would need the Excel/Office CD and follow the instructions to
install it.


--


Regards,


Peo Sjoblom
 
if you're using a version of Excel prior to Excel 2207.

I wonder if we'll still be dealing with the ribbon in that version? <g>
 
Back
Top