COUNTIFS and within the last 30 days

EB1209 · 01/02/25

Hello everyone. I trying to count specific reporting events that have been submitted/created within the last 30 days.

Pic 1 - Source sheet "TCIO Task Reporting - Master"

Pic 2 - Rollup Metrics Sheet (feeds dashboard)

Here is the unparseable formula that I am currently using to capture all CM reporting events created within the last 30 days.

=COUNTIFS({TCIO Task Input Range 1}, Category@row), AND({TCIO Task Input - Master Range 1}, >TODAY(-30))

Paul Newcome · 01/02/25

Try this instead:

=COUNTIFS({TCIO Task Input Range 1}, Category@row, {TCIO Task Input - Master Range 1}, >TODAY(-30))

Paul Newcome · 01/02/25

Try this instead:

=COUNTIFS({TCIO Task Input Range 1}, Category@row, {TCIO Task Input - Master Range 1}, >TODAY(-30))

EB1209 · 01/03/25

This worked! Thank you very much for your assistance.

Paul Newcome · 01/03/25

Happy to help. 👍️

Best Answer