Two columns of data - first formula looks for target month...which is in this case is July:
=SUMPRODUCT(--(D2:D10<>""),--(MONTH(D2:D10)=7))

Second formula looks for a keyword. I have to report when I post clients to new adult family homes to my supervisor. Second formula:

=COUNTIF(G2:G5,"for*")

the "for" would be like "kitsap family home" etc. I used "for" to simplify.

If I had 20 dates in July, but only 5 "for" during the month, that is what I would like. I'm feeling like this might be a nested formula answer?
Thank you!