Okay, so I have another one. I'm trying to count all the people who have a term date within a certain month. That month will change and will be listed as of the end of the month. So, for August, the date is August 31, 2023. I'm looking for everyone with an August 2023 date.
The formula I currently have is in G3. It's =COUNTIF(B:B,TEXT(G1,"MM/YYYY")) and it's not working. It's bringing back 1 (probably because it's seeing the 8/31/2023 record). It should bring back 3.
It's Friday and my brain isn't firing on all cylinders yet... What am I missing? I feel like it's something obvious.
Bookmarks