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.

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.

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.