What version of Excel are you using?

Here's one way...

=SUMPRODUCT(--(TEXT(C2:C100,"m/yyyy")="12/2009"))

--
Biff
Microsoft Excel MVP


"EXCELably Challenged" <EXCELably
wrote in message ...
I need to count the number of occurances of a date range from a column of
dates spanning from December 1, 2009 - March 15, 2010. (how many dates in
column C are in the month of december 2009). How do i write a formula
that
will recogize the date? thanks