Count Number of Events using both Month and Year

[Redders15]

Hi

Please refer to attached example spreadsheet.

Using separate tabs within the same spreadsheet, I require to tally up the number of times a date (i.e. Jan 2021) is entered under the Date raised (A5:11) column under Tab 1. Tab 2, E4 requires the formula.

I have seen similar formulas on here but can't get them t work as different to what I need.

Kind Regards

[AliGW]

In E4 copied across:

=COUNTIFS($A$5:$A$11,">="&E$3,$A$5:$A$11,"<="&EOMONTH(E$3,0))

[Limor_OP]

Hi
please try this in E4 and drag to the right:
=SUM(--(MONTH($A$5:$A$11)=MONTH(E3)))

EDIT:

sorry didn't notice the year issue, here is my amendment:
=SUM(--(($A$5:$A$11) > =(E3))*((($A$5:$A$11) < EOMONTH(E3,0)+1)))

[Redders15]

Hi Ali

It works on the example you sent, but I can't get it to work on the actual spreadsheet, think it may have something to do with the cell I'm referencing which is E3 on the example.
The actual spreadsheet is set as a date showing Month and year. Will it have something to do with that?

Thanks

[CARACALLA]

Sheet2

E4=SUMPRODUCT((Sheet1!$A$5:$A$100<>"")*(MONTH(Sheet1!$A$5:$A$100)=MONTH(Sheet2!E$3))*(YEAR(Sheet1!$A$5:$A$100)=YEAR(Sheet2!E$3)))

for hide 0 custom format [=0]""

[AliGW]

Will it have something to do with that?

Probably, but if you give me chalk and then try to apply what I wrote for chalk to cheese, and cheese that I can't even see, then it's over to you.

Sample workbooks need to properly represent the real data, otherwise they are next to useless.