SOLVED

Count Dates in Month

Copper Contributor

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 January2 
01/01/2023 February1
01/02/2023    

Please advise

1 Reply
best response confirmed by Adam08780 (Copper Contributor)
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".

count dates in months.png

1 best response

Accepted Solutions
best response confirmed by Adam08780 (Copper Contributor)
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".

count dates in months.png

View solution in original post