Count specific days in between dates

  • Thread starter Thread starter Gabe
  • Start date Start date
G

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.
 
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.
 
Thank You!

Mike H said:
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.
Click to expand...
 
Back
Top