Hello,
I hope to get some help with a formula. The part I can get is this-
=COUNTIF(C:C,"*Philip*")
The part I can't figure out is how to do that based off of a date range in column B.
I would like the formula to count how many times *Philip* appears in column C for the month of January which is in column B.
The date format is 01/01/2023
Thank you for any help,
Lea
I hope to get some help with a formula. The part I can get is this-
=COUNTIF(C:C,"*Philip*")
The part I can't figure out is how to do that based off of a date range in column B.
I would like the formula to count how many times *Philip* appears in column C for the month of January which is in column B.
The date format is 01/01/2023
Thank you for any help,
Lea