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 specific days in between dates
Hello,
I am trying to count a specific number of days in between 2 dates. For example, if I specify a certain date range of: Start Date: 01/01/2010 End Date: 12/31/2010 and my fixed days a 01/02/2010 04/01/2010 02/01/2011 then the formula would return: 2 I guess this would be similar to counting the number of holidays within a given date range. Any suggestions would be very much appriciated. |
#2
|
|||
|
|||
Count specific days in between dates
Hi,
Start date in A1, End date in a2 and the days to count in B1:B3 =SUMPRODUCT((B1:B3=A1)*(B1:B3=A2)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Gabe" wrote: Hello, I am trying to count a specific number of days in between 2 dates. For example, if I specify a certain date range of: Start Date: 01/01/2010 End Date: 12/31/2010 and my fixed days a 01/02/2010 04/01/2010 02/01/2011 then the formula would return: 2 I guess this would be similar to counting the number of holidays within a given date range. Any suggestions would be very much appriciated. |
#3
|
|||
|
|||
Count specific days in between dates
Thank You!
"Mike H" wrote: Hi, Start date in A1, End date in a2 and the days to count in B1:B3 =SUMPRODUCT((B1:B3=A1)*(B1:B3=A2)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Gabe" wrote: Hello, I am trying to count a specific number of days in between 2 dates. For example, if I specify a certain date range of: Start Date: 01/01/2010 End Date: 12/31/2010 and my fixed days a 01/02/2010 04/01/2010 02/01/2011 then the formula would return: 2 I guess this would be similar to counting the number of holidays within a given date range. Any suggestions would be very much appriciated. |
Thread Tools | |
Display Modes | |
|
|