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