Formula for counting dates in a month

Aaron Kennedy

I need to count how many jobs there were per month on another sheet, any tips on how to make the "COUNTIF" or "DATE"

My current formula for the month of January that comes up as "Unparseable"

=COUNTIFS({Date}, AND((>=DATE(2024,1,1), <=DATE(2024,1,31))))

{Date} is the column from the other sheet

Help would be appreciated

heyjay

Since you are using COUNTIFS, AND function is no longer needed. Can you try this -

=COUNTIFS(
{Date}, >=DATE(2024,1,1), 
{Date}, <=DATE(2024,1,31)