If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
count days in a date range
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 |
#3
|
|||
|
|||
count days in a date range
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 . |
#4
|
|||
|
|||
count days in a date range
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 . |
#5
|
|||
|
|||
count days in a date range
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 . . |
#6
|
|||
|
|||
count days in a date range
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 . . |
#7
|
|||
|
|||
count days in a date range
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 |
Thread Tools | |
Display Modes | |
|
|