Count of specific values in a date range

Originally Posted by Nitin.Agr

=COUNTIFS($C$1:$C$12,"*def*",$A$1:$A$12,">="&DATE(2015,2,1),$A$1:$A$12,"<"&DATE(2015,3,1))

Looks like you also missed this:

Originally Posted by bobbych

I forgot to mention i need the formula to be compatible with Excel 2003