Update cell value based on outcome of search function & if statement

[srosk]

I have a list of values in column C. There is a list of 10 values, where if present, I would like the value in column I to be updated to "_". But, I only want any of this to occur if today's date is before 1/1/2022.

I know I can use the search function to see if the value exists, but how exactly would I queue the macro to clear the values?

=SEARCH("1528",C2)

Thank you kindly!

 

[LouisT]

This formula should work: =IF(TODAY()<SEARCH("1528",C2),"_","")

I have a list of values in column C. There is a list of 10 values, where if present, I would like the value in column I to be updated to "_". But, I only want any of this to occur if today's date is before 1/1/2022.

I know I can use the search function to see if the value exists, but how exactly would I queue the macro to clear the values?

=SEARCH("1528",C2)

Thank you kindly!