Counting records based on date

Kernesa Samana

I want to count the number of records in my list that are due in the next 30 days, but I'm getting an #unparseable error:

=COUNTIF([Targeted Completion Date]:[Targeted Completion Date],[Targeted Completion Date]<=TODAY(30)

Eventually I'll add an additional condition to only count how many High priority items are due within 30 days- but if I can figure out the base count, I think I will be able to add conditions.

Any ideas what's wrong with my formula?

Genevieve P.

Hi @Kernesa Samana

You don't need to repeat the column name after you've listed it as a range, you can instead jump right into the criteria! You're also missing a closing parentheses at the end to finish off the COUNTIF statement.

Try this:

=COUNTIF([Targeted Completion Date]:[Targeted Completion Date], <=TODAY(30))

Keep in mind this is counting everything that's less than 30 days from now, without stopping at Today. If you want to count between a range, you'll want to use COUNTIFS (plural) to identify two criteria.

Try this:

=COUNTIFS([Targeted Completion Date]:[Targeted Completion Date], <=TODAY(30), [Targeted Completion Date]:[Targeted Completion Date], >= TODAY())

Cheers,

Genevieve