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.

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.

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.