How do I make the following formula time bound and not just "after 2024, 1, 1?

dawn.peterson

=COUNTIFS({Created}, >=DATE(2024, 1, 1), {Physician Process SOAR 1.0 Range 1}, [Visit Type 2024]@row, {Physician Process SOAR CFT NAME}, CONTAINS("Boomer, Mark", @cell))

Hello all,

Need group think/help here. The above formula calculates for me the number I need after creation date of (2024, 1, 1) which was great when I look at year to date in 2024, however now that we are in 2025, I need the formula to only count those numbers between (2024, 1, 1) AND (, 1, 1). Help! Thank you!

Darren Mullen

@dawn.peterson

I think you want to count only those in 2024?

If so 2 options:

1.

=COUNTIFS({Created}, and(@cell >=DATE(2024, 1, 1), @cell <=DATE(2024, 12, 31) ), {Physician Process SOAR 1.0 Range 1}, [Visit Type 2024]@row, {Physician Process SOAR CFT NAME}, CONTAINS("Boomer, Mark", @cell))

2. =COUNTIFS({Created}, year(@cell) = 2024, {Physician Process SOAR 1.0 Range 1}, [Visit Type 2024]@row, {Physician Process SOAR CFT NAME}, CONTAINS("Boomer, Mark", @cell))

dawn.peterson

Thanks Darren. Just tried both and still got an error. :-( Could it be that I don't have the year in a separate column or row?

Darren Mullen

@dawn.peterson A lot of times I end up putting a "year" date in the sheet because it simplifies these sorts of calculations.

That would be the easiest way, if you don't mind adding another column.

What error are you getting?

dawn.peterson

Thanks, but putting the year in the sheet won't work. We are already almost maxed out to the 500K cell sheet limit. Keep getting the #Un… error.