How do I get a number count of dates that fall between specific dates

  • Thread starter Thread starter JohnB
  • Start date Start date
J

JohnB

I need to get a count of dates that fall in between for example A2 an
A12.

ie.

If A2:A12>38133 and a2:12<38138


Thanks for the hel
 
=COUNTIF(A1:A12,">"&DATE(2004,5,26))-COUNTIF(A1:A12,"<"&DATE(2004,5,31))

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
try
=sumproduct((a2:a12>38133)*(a2:a12<38138))
or

=sumproduct((a2:a12>b1)*(a2:a12<b2))
 
I need to get a count of dates that fall in between for example A2 and
A12.

ie.

If A2:A12>38133 and a2:12<38138


Thanks for the help
Click to expand...

=COUNTIF(A2:A12,">="&DATE(2004,5,26)) - COUNTIF(A2:A12,">"&DATE(2004,5,31))


--ron
 
Back
Top