Count specific days in between dates

[Gabe]

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 are:
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.

 

[Mike H]

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]

Thank You!

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.