If Contains Specific Year Formula

Kaykay

Hi,

I'm trying to use a formula that will look at a date column to populate another column. If year in that date column is 2022 I want the new column to say Not applicable, but my formula is not working.

=IF(CONTAINS(YEAR(2022), [First Receive]@row), "Not Applicable", "") but it's giving me an invalid data type error

Christian Graf

Hello @Kaykay

Try something like this:

=IF(YEAR(Date@row) = 2022, "Not Applicable","")

Hope this helps!

Christian Graf

Hello @Kaykay

Try something like this:

=IF(YEAR(Date@row) = 2022, "Not Applicable","")

Hope this helps!

Alan P.

Try this:

=IF(RIGHT([First Receive]@row, 2) = "22", "Not Applicable", "")

For some reason, none of the date functions seem to work, and using RIGHT with more than 2 characters isn't working either. I found that using just 2 characters from the right worked well

Kaykay

Thank you so much you guys! It worked. :) Have a wonderful day!