Countif a range of dates

[Scott]

I have a spreadsheet containing a range of sale dates,
sale values, sale details etc etc

eg - dates 06-Feb-04 01-Mar-04 10-May-04 15-Jan-04 12-Jan-
04 29-Jan-04 30-Jan-04 3-Mar-04 14-Apr-04 19-May-04 27-May-
04 8-Jun-04

i need to find the number of instances in a particular
month eg Mar-04

i have tried the countif using <> for dates but dont get
the right answer.

 

[Norman Harker]

Hi Scott

One way:

=SUMPRODUCT(--(TEXT($A$1:$A$100,"mmm")="Mar"),--(YEAR($A$1:$A$100)=2004))

 

[ivano]

Type in B1 the number of the month...Es 1 (genuary)
and the array formula:
=SUM(--(COUNTIF($B$1,MONTH($A$1:$A$7))))

 

[Guest]

Thanks to Norman & Ivano for your assistance which gave me
the right result and made me look like a star.

Scott