Count Dates in Month

[Adam08780]

I've been trying formulas online but cannot get them to work. How to count by month - count month with COUNTIFS and EOMONTH (spreadsheetweb.com)

I want to count the number of times a UK date appears for each month

			Count
01/01/2023		January	2
01/01/2023		February	1
01/02/2023

Please advise

[#2 · Accepted solution]

@Adam08780 

=COUNTIFS($A$2:$A$4,"<="&EOMONTH(C2,0),$A$2:$A$4,">"&EOMONTH(C2,-1))

This formula returns the intended result in my sheet. The values in cells C2 and C3 are 01.01.2023 and 01.02.2023 which are formatted as "mmmm".