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)

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)

Paul Newcome

You can use the AND function to avoid having to repeat the {Range}. You just had some extra parenthesis and needed "@cell" references.

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

But since it looks like you are trying to pull everything for the entire year, you could also use

=COUNTIFS({Date}, IFERROR(YEAR(@cell), 0) = 2024)