CountIF for months

[JoelBrown1990]

Hi All,

I need a formula for counting how many dates fall within a certain month within a column. The dates are in DD/MM/YYYY format.

Any help would be appreciated.

Many thanks,
Joel

 

[Fluff]

How about something like

=COUNTIFS(A:A,">="&DATE(2023,1,1),A:A,"<"&DATE(2023,2,1))

 

[JoelBrown1990]

How about something like

=COUNTIFS(A:A,">="&DATE(2023,1,1),A:A,"<"&DATE(2023,2,1))

Thank you. Works perfect.

 

[Fluff]

You're welcome & thanks for the feedback.