|
networkdays function
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!? |
networkdays function
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!? |
networkdays function
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!? |
networkdays function
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!? |
networkdays function
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 |
networkdays function
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 |
networkdays function
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 |
| All times are GMT +1. The time now is 03:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com