Hi, I'm trying to create a countifs formula that includes a month condition, and can't figure out how to configure the date portion. This is what I have
=COUNTIFS(M:M;"specifictext";Q:Q;"specifictext";!I:I;"7/") (what's in bold I know is wrong)
I:I are where the dates are, cells are date cells and formatted mm/dd/yyyy. I can't do I:I;"July" or I:I;"7/" or I:I;"*7/*". How would I incorporate a month condition? I also can't convert the date to text as it spits it out as a decimal number instead.
