Countif range to only recognize text in a range

[jaxs2009]

Hello everyone, I am using excel 2007

In sheet "DASH BOARD" cell E26 have this formula =COUNTIF('PROJECT TRACKING'!CM6:CM304,"In Process"). it works great

Could this formula be edited in cell E30 same range =COUNTIF('PROJECT TRACKING'!CM6:CM304 recognize only the abbreviated text of a date (example of cell date format 15-Jan) I just want to count the "Jan" in this range

Thank you

 

[etaf]

is it a real date or text
countifs()
should work in 2007 version

=COUNTIFS('PROJECT TRACKING'!CM6:CM304,"In Process", Cell range with the date , ">="&datevalue("1-jan-2019"),Cell range with the date , "<="&datevalue("31-jan-2019") )
But must be a date

 

[jaxs2009]

Thank you, that works, its one of the longest formula I have used. the date format for the cells in the range is "15-Jan"

 

[etaf]

you are welcome