Trying to subtract 1 year.

frob

I'm trying to count rows for 2022 in a set of data. Below is the formula I was trying. I have a column called years in the main data that parses out the year from the timestamp. What am I doing wrong?

=COUNTIFS({URV 2 Years Range chem}, true, {URV 2 Years Year}, YEAR(TODAY() - 1))

KPH

Instead of YEAR(TODAY() - 1)

try

YEAR(TODAY()) - 1

KPH

Instead of YEAR(TODAY() - 1)

try

YEAR(TODAY()) - 1

frob

I feel like a dummy but thank you so much for helping! That did it.

KPH

No problem. I bet you were focused on extracting the year from a date stamp and thinking the complex part was the issue. 😀