Count number of occurrence between dates

I need to count the number of occurrences fall between week of dates. See Attached Week Of tab and Response data Column M.

You need this formula:

=COUNTIFS('Response data'!$A:$A,">="&$AA4,'Response data'!$A:$A,"<="&$AB4,'Response data'!$M:$M,C$3)

But your column M of Response Data contains Words, whether c$3 of Week Of contains Number. So it will result 0 every time. So, can you explain what is C$3 in Week Of?

C-3 is the week of July 4 through July 8 I think so what I'm trying to do is break down the data for each of the headers on the tab the week off. In the column M will be words like self cutting, suicide, homicide works that are in the headers

Then you can use this formula :

=COUNTIFS('Response data'!$A:$A,">="&$AA4,'Response data'!$A:$A,"<="&$AB4)

I can not get the [CODE]=COUNTIFS('Response data'!$A:$A,">="&$AA4,'Response data'!$A:$A,"<="&$AB4)/CODE] to work at all. I'm trying to get it to count the number of times "Suicidal" or "Homicidal" show up in Column M. for each week of C4:C55.

Try this to count Suicidal :

=COUNTIFS('Response data'!$A:$A,">="&$AA4,'Response data'!$A:$A,"<="&$AB4,'Response data'!$A:$A,"Suicidal")

And this to count Homicidal :

=COUNTIFS('Response data'!$A:$A,">="&$AA4,'Response data'!$A:$A,"<="&$AB4,'Response data'!$A:$A,"Homicidal")