my two dates:
h131=1/14/2008 i131=1/22/2008
formula used: =networkdays(h131, i131)
answer given = 7
real answer should be 5 correct (subtract sat and sunday and get 5)

thanks
"Jeff Boyce" wrote:

We aren't there. We can't see what you're looking at.

More specific description is likely to lead to more specific suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"whahappened..." wrote in message
...
i installed the analysis pack and yet it is still calculating one extra
weekend. I attempted with the date function (=date(year, month, day)) and
with just a normal date; however, it is still giving me 7 instead of 5!
What
I am doing wrong!?

Mon, January 14, 2008.....workday
Tue, January 15, 2008.....workday
Wed, January 16, 2008.....workday
Thu, January 17, 2008.....workday
Fri, January 18, 2008.....workday
Sat, January 19, 2008.....WEEKEND
Sun, January 20, 2008.....WEEKEND
Mon, January 21, 2008.....workday
Tue, January 22, 2008.....workday

Looks like 7 workdays to me.

What were you expecting?

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"whahappened..." wrote in message
...
my two dates:
h131=1/14/2008 i131=1/22/2008
formula used: =networkdays(h131, i131)
answer given = 7
real answer should be 5 correct (subtract sat and sunday and get 5)

thanks
"Jeff Boyce" wrote:

We aren't there. We can't see what you're looking at.

More specific description is likely to lead to more specific
suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"whahappened..." wrote in
message
...
i installed the analysis pack and yet it is still calculating one extra
weekend. I attempted with the date function (=date(year, month, day))
and
with just a normal date; however, it is still giving me 7 instead of 5!
What
I am doing wrong!?

OHHHHHHHHHHHHHHHHHH

So I guess I need it to NOT count the actual days, IE: not count the 14th
and the 22nd as days either! Now I get why it is getting the 7, but how can
I get it to calculate only the days within the boundary, NOT including the
boundary?

"Ron Coderre" wrote:

Mon, January 14, 2008.....workday
Tue, January 15, 2008.....workday
Wed, January 16, 2008.....workday
Thu, January 17, 2008.....workday
Fri, January 18, 2008.....workday
Sat, January 19, 2008.....WEEKEND
Sun, January 20, 2008.....WEEKEND
Mon, January 21, 2008.....workday
Tue, January 22, 2008.....workday

Looks like 7 workdays to me.

What were you expecting?

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"whahappened..." wrote in message
...
my two dates:
h131=1/14/2008 i131=1/22/2008
formula used: =networkdays(h131, i131)
answer given = 7
real answer should be 5 correct (subtract sat and sunday and get 5)

thanks
"Jeff Boyce" wrote:

We aren't there. We can't see what you're looking at.

More specific description is likely to lead to more specific
suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"whahappened..." wrote in
message
...
i installed the analysis pack and yet it is still calculating one extra
weekend. I attempted with the date function (=date(year, month, day))
and
with just a normal date; however, it is still giving me 7 instead of 5!
What
I am doing wrong!?

If you know that the end days are not weekend dates, then just subtract 2
from the NETWORKDAYS result.
If the end days might be weekend dates, you'll need to test them (with the
WEEKDAY function), and then subtract as appropriate.
--
David Biddulph

"whahappened..." wrote in message
...
OHHHHHHHHHHHHHHHHHH

So I guess I need it to NOT count the actual days, IE: not count the 14th
and the 22nd as days either! Now I get why it is getting the 7, but how
can
I get it to calculate only the days within the boundary, NOT including the
boundary?

"Ron Coderre" wrote:

Mon, January 14, 2008.....workday
Tue, January 15, 2008.....workday
Wed, January 16, 2008.....workday
Thu, January 17, 2008.....workday
Fri, January 18, 2008.....workday
Sat, January 19, 2008.....WEEKEND
Sun, January 20, 2008.....WEEKEND
Mon, January 21, 2008.....workday
Tue, January 22, 2008.....workday

Looks like 7 workdays to me.

What were you expecting?

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"whahappened..." wrote in message
...
my two dates:
h131=1/14/2008 i131=1/22/2008
formula used: =networkdays(h131, i131)
answer given = 7
real answer should be 5 correct (subtract sat and sunday and get 5)

thanks
"Jeff Boyce" wrote:

We aren't there. We can't see what you're looking at.

More specific description is likely to lead to more specific
suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"whahappened..." wrote in
message
...
i installed the analysis pack and yet it is still calculating one
extra
weekend. I attempted with the date function (=date(year, month,
day))
and
with just a normal date; however, it is still giving me 7 instead of
5!
What
I am doing wrong!?

On Tue, 15 Jan 2008 22:02:44 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

If you know that the end days are not weekend dates, then just subtract 2
from the NETWORKDAYS result.
If the end days might be weekend dates, you'll need to test them (with the
WEEKDAY function), and then subtract as appropriate.
--
David Biddulph

Or, he can just add one to the start date, and subtract one from the end date
--ron

Yes, that sounds much simpler, Ron.
--
David Biddulph

"Ron Rosenfeld" wrote in message
...
On Tue, 15 Jan 2008 22:02:44 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

If you know that the end days are not weekend dates, then just subtract 2
from the NETWORKDAYS result.
If the end days might be weekend dates, you'll need to test them (with the
WEEKDAY function), and then subtract as appropriate.
--
David Biddulph

Or, he can just add one to the start date, and subtract one from the end
date
--ron

On Tue, 15 Jan 2008 13:45:02 -0800, whahappened...
wrote:

OHHHHHHHHHHHHHHHHHH

So I guess I need it to NOT count the actual days, IE: not count the 14th
and the 22nd as days either! Now I get why it is getting the 7, but how can
I get it to calculate only the days within the boundary, NOT including the
boundary?

=networkdays(h131+1, i131-1)


--ron