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

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.

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 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???

That worked. Thanks :-)

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.

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