Adding the year into a formula

Paige B

Good Morning,

I am trying to add a year of 2025 into my below formula and for some reason how i thought it would go isnt working, any ideas:

=COUNTIFS({BSA Audit Database Client}, [Primary Column]$1, {BSA Audit Database Date of audit}, MONTH(@cell ) = 8, {BSA Audit Database RAG}, RAG@row )

Thank you.

Cassie L

@Paige B This is possible — but I have not found a way around using a helper column that identifies the year.

So you'd need one Helper Year Column that is something like =YEAR([Date Column]@row), which would produce "2025".

Then update formula to:

=COUNTIFS({BSA Audit Database Client}, [Primary Column]$1, {BSA Audit Database Date of audit}, MONTH(@cell ) = 8, {BSA Audit Database RAG}, RAG@row, [Helper Year Column], "2025")