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
hello
what about if i have in the same day 3 entries like 1-july 20 7:20
1-july-20 7:25
1-july-20 7:30
will it still work, as these are different dates for excel, it will show 3 items in the row label isnt?
what about if i have in the same day 3 entries like 1-july 20 7:20
1-july-20 7:25
1-july-20 7:30
will it still work, as these are different dates for excel, it will show 3 items in the row label isnt?
Riny_van_Eekelen
Jan 26, 2022Platinum Contributor
Well, give it a try and see what happens.