Formula to test for Date + If Date Is Within One Year

SEBERCAW

I know that =IF(DATE@row <> "", "Green", "Red") will tell be if there is a Date.

I need to add one more condition. That the date is also within the last year.

Can someone please help me?

I want the column to be Red if either condition fails and Green if both conditions are met.

ker9

Hi @SEBERCAW

See if this is what you need:

=IF(AND(Date@row <> "", Date@row >= TODAY() - 365), "Green", "Red")

Hope this helps!