Forum Discussion
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...
The criteria is your input variables. You define the month and date you want to count.
The count row shows the count. Here are the formulas used:
COUNTIF(H8:H18,H4) in H5
COUNTIF(I8:I18,I4) in I5
COUNTIF(K8:K18,K4) in K5
COUNTIF(L8:L18,L4) in L5
Now for the columns 'Isolating Month' and 'Isolating Date':
MONTH(G8) for (H)
DAY(G8) for (I)
TEXT(DATE(,MONTH(G8),),"mmm") for (K)
(L) shares the same formula as (I)
To use year along with month, in (K) use:
TEXT(DATE(YEAR(G8),MONTH(G8),),"mmm"&" "&"yyyy")
Make sure to use 'Month 2021' in K5. Note Month should be 3 letters. make changes to the formulas if you want months to be shown differently.
TEXT(DATE(YEAR(G8),MONTH(G8),),"mmm"&" "&"yyyy")
Make sure to use 'Month 2021' in K5. Note Month should be 3 letters. make changes to the formulas if you want months to be shown differently.