SOLVED

# Count Dates in Month

Copper Contributor

# Count Dates in Month

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

best response confirmed by Adam08780 (Copper Contributor)
Solution

# Re: Count Dates in Month

=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".

1 best response

Accepted Solutions
best response confirmed by Adam08780 (Copper Contributor)
Solution

# Re: Count Dates in Month

=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".