=SUMPRODUCT(--(TEXT(A1:A1000,"mmmyy")="Dec05"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"gpoky" wrote in message
...
I have a range of cells with dates (mm/dd/yy). I wish to count how many
entries I have in a monthly time period. i.e. how many insances do I have
in
December 05?