Counting dates

J

jdavis3874

I am trying to count the number of dates in a column that appear b
month and year. For instance, I some that are 11/23/2003 and 11/24/200
and 11/21/2002. How can I makew a formula that will count the instance
of 11/2003
 
B

Bob Phillips

=SUMPRODUCT((YEAR(A1:A100)=2004)*(MONTH(A1:A100)=11))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
C

CLR

=COUNTIF(C1:C20,">37925")-COUNTIF(C1:C20,">37955")
or
=COUNTIF(C1:C20,">10/31/03")-COUNTIF(C1:C20,">11/30/03")

Vaya con Dios,
Chuck, CABGx3
 
Top