Forum Discussion
alexesprtu
Jan 26, 2022Copper Contributor
COUNT IF FORMULA for month/year only
Hi guys, I want to count rows based on the month year. The column I want to count is in this format: 27/07/2021 0:00 but I want to count it by month/year only. eg: Jul 2021 Au...
chahine
Jan 26, 2022Iron Contributor
if you convert the range to pivot table & put the dates in rows & put again dates in values (select count there), so it will count how many month year u have