count days in a date range

I am trying to count the number of days within a given
date range but leave out saturday's and Sunday's. Is
there a way to do this? Using the function Days360 seems
to be the right path, and counts all the days between the
range, but I am not sure how to customize from there, if
it is even possible.

cp

Hi
if your dates are in a and B1 use
=NETWORKDAYS(A1,B1,list_of_holidays)

Note: the Analysis Toolpak Add-in has to be installed for this


--
Regards
Frank Kabel
Frankfurt, Germany


cp wrote:
I am trying to count the number of days within a given
date range but leave out saturday's and Sunday's. Is
there a way to do this? Using the function Days360 seems
to be the right path, and counts all the days between the
range, but I am not sure how to customize from there, if
it is even possible.

cp

Do you know where I can download the toolpak? I use Excel
2000 on a Windows XP operating system. I did find a site
on Microsoft at:
http://www.microsoft.com/downloads/details.aspx?
FamilyID=01902294-9e3f-487f-b7b0-
e310fe2d5362&DisplayLang=en

but was not positive it was what you were refering to.

Also, will this function be able to calculate a date
range and leave out just Sunday, vs. the entire weekend?

cp
-----Original Message-----
Hi
if your dates are in a and B1 use
=NETWORKDAYS(A1,B1,list_of_holidays)

Note: the Analysis Toolpak Add-in has to be installed
for this


--
Regards
Frank Kabel
Frankfurt, Germany


cp wrote:
I am trying to count the number of days within a given
date range but leave out saturday's and Sunday's. Is
there a way to do this? Using the function Days360
seems
to be the right path, and counts all the days between
the
range, but I am not sure how to customize from there,
if
it is even possible.

cp
.

Hi
it's included on your installation CDs. Goto 'Tools - addin' and check
this Add-in

--
Regards
Frank Kabel
Frankfurt, Germany


cp wrote:
Do you know where I can download the toolpak? I use Excel
2000 on a Windows XP operating system. I did find a site
on Microsoft at:
http://www.microsoft.com/downloads/details.aspx?
FamilyID=01902294-9e3f-487f-b7b0-
e310fe2d5362&DisplayLang=en

but was not positive it was what you were refering to.

Also, will this function be able to calculate a date
range and leave out just Sunday, vs. the entire weekend?

cp
-----Original Message-----
Hi
if your dates are in a and B1 use
=NETWORKDAYS(A1,B1,list_of_holidays)

Note: the Analysis Toolpak Add-in has to be installed for this


--
Regards
Frank Kabel
Frankfurt, Germany


cp wrote:
I am trying to count the number of days within a given
date range but leave out saturday's and Sunday's. Is
there a way to do this? Using the function Days360 seems
to be the right path, and counts all the days between the
range, but I am not sure how to customize from there, if
it is even possible.

cp
.

Thank you. Also, will this function be able to calculate
a date range and leave out just Sunday, vs. the entire
weekend?

-----Original Message-----
Hi
it's included on your installation CDs. Goto 'Tools -
addin' and check
this Add-in

--
Regards
Frank Kabel
Frankfurt, Germany


cp wrote:
Do you know where I can download the toolpak? I use
Excel
2000 on a Windows XP operating system. I did find a
site
on Microsoft at:
http://www.microsoft.com/downloads/details.aspx?
FamilyID=01902294-9e3f-487f-b7b0-
e310fe2d5362&DisplayLang=en

but was not positive it was what you were refering to.

Also, will this function be able to calculate a date
range and leave out just Sunday, vs. the entire
weekend?

cp
-----Original Message-----
Hi
if your dates are in a and B1 use
=NETWORKDAYS(A1,B1,list_of_holidays)

Note: the Analysis Toolpak Add-in has to be installed
for this


--
Regards
Frank Kabel
Frankfurt, Germany


cp wrote:
I am trying to count the number of days within a
given
date range but leave out saturday's and Sunday's. Is
there a way to do this? Using the function Days360
seems
to be the right path, and counts all the days
between the
range, but I am not sure how to customize from
there, if
it is even possible.

cp
.

.

Hi
for this you may use the following array formula (entered with
CTRL+sHIFT+ENTER):
=B1-A1-SUM(IF(WEEKDAY(A1-1+ROW(INDIRECT("1:"&TRUNC(B1-A1)+1)))=1,1,0))

--
Regards
Frank Kabel
Frankfurt, Germany


cp wrote:
Thank you. Also, will this function be able to calculate
a date range and leave out just Sunday, vs. the entire
weekend?

-----Original Message-----
Hi
it's included on your installation CDs. Goto 'Tools - addin' and
check this Add-in

--
Regards
Frank Kabel
Frankfurt, Germany


cp wrote:
Do you know where I can download the toolpak? I use Excel
2000 on a Windows XP operating system. I did find a site
on Microsoft at:
http://www.microsoft.com/downloads/details.aspx?
FamilyID=01902294-9e3f-487f-b7b0-
e310fe2d5362&DisplayLang=en

but was not positive it was what you were refering to.

Also, will this function be able to calculate a date
range and leave out just Sunday, vs. the entire weekend?

cp
-----Original Message-----
Hi
if your dates are in a and B1 use
=NETWORKDAYS(A1,B1,list_of_holidays)

Note: the Analysis Toolpak Add-in has to be installed for this


--
Regards
Frank Kabel
Frankfurt, Germany


cp wrote:
I am trying to count the number of days within a given
date range but leave out saturday's and Sunday's. Is
there a way to do this? Using the function Days360 seems
to be the right path, and counts all the days between the
range, but I am not sure how to customize from there, if
it is even possible.

cp
.

.

Why don't you count ALL the days (easy enough), divide by 7 to get weeks,
and take 2 x [Number of weeks] off the total days ? You question further on
about only Sundays - take 1 x [Number of weeks] off. If you're worried about
part weeks, check first to see what day the period starts with, and work
from there.

Rob

"cp" wrote in message
...
I am trying to count the number of days within a given
date range but leave out saturday's and Sunday's. Is
there a way to do this? Using the function Days360 seems
to be the right path, and counts all the days between the
range, but I am not sure how to customize from there, if
it is even possible.

cp