How to find specific text within a string, in a COUNTIFS statement
I am using a COUNTIFS to search a linked sheet, with one of the conditional IFS to be if the date falls in a specific month.
So Condition 1, Condition 2, Condition 3 = Must have "Jan" in referenced dates
Have tried "*"&"jan"&"*" as both an IF, and as part of a nested FIND statement - both to no success.
Any tips please?
Help Article Resources
Check out the Formula Handbook template!