How to count a field which has a certain character in it.

MelanieJohn

I have a field with the date formatted as 09/30/2024. I would like to summarize that field with the count of lines containing 09 and 2024 (so basically by the month and year).

I am attempting just for the month and can not get it to work.

=COUNTIFS([Next Renewal Date]:[Next Renewal Date], CONTAINS("09")

But I would also like it to look at the year if possible.

Michelle Choate 2

I always have a MONTH column and YEAR column on all my sheets. They have formulas that look at dates that are just =MONTH([Next Renewal Date]@row) and =YEAR([Next Renewal Date]@row). Then I use my COUNTIFS formula based off of those because with your current formula it will also count the ninth day of every month.

Michelle Choate 2

I always have a MONTH column and YEAR column on all my sheets. They have formulas that look at dates that are just =MONTH([Next Renewal Date]@row) and =YEAR([Next Renewal Date]@row). Then I use my COUNTIFS formula based off of those because with your current formula it will also count the ninth day of every month.

MelanieJohn

Thank you! I was thinking that was the answer but was unsure if there was a way to "Look up". I will adjust the sheet and separate the month and year.