Trying to get work days out of two dates
 

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.

Trying to get work days out of two dates
 

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.
--
John C


"erick-flores" wrote:

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.

Trying to get work days out of two dates
 

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)

--
Biff
Microsoft Excel MVP


"erick-flores" wrote in message
...
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.

Trying to get work days out of two dates
 

Thanks for ur reply.

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

What do I need check?

Thanks

Trying to get work days out of two dates
 

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

Any ideas???

Trying to get work days out of two dates
 

Nothing wrong, you need to go to toolsadd-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

"erick-flores" wrote in message
...
I tried on MS Excecl 2007 and it worked just fine. I wonder what can
be wrong in MS Excel 2003.

Any ideas???

Trying to get work days out of two dates
 

That worked. Thanks :-)

Trying to get work days out of two dates
 

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

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
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)

--
Biff
Microsoft Excel MVP


"erick-flores" wrote in message
...
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.

Trying to get work days out of two dates
 

You need to check MS help on NETWORKDAYS, as John C recommended.
--
David Biddulph

"erick-flores" wrote in message
...
Thanks for ur reply.

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

What do I need check?

Thanks