Need help counting text attributed to a person for corresponding week & month numbers

[Unexist]

I want to know how many times John, Nick and Rambo got "planned" in the corresponding week- and month-numbers.

[José Augusto]

Hi

Change data in J4:M4 to 6, 7, 8, 9
Change data in J9:L9 to 01/02/2018, 01/03/2018, 01/04/2018 and format as date "mmmm"

Try this formulas in J5 and j12. and copy for the other cells

Please Login or Register  to view this content.

Please Login or Register  to view this content.

See the file

[Unexist]

Thanks José, it worked perfect!

[José Augusto]

You are welcome.

Do not forget to mark this thread as SOLVED.

Best regards.

[Unexist]

Done. Thanks again, you're the best