Formula to test for Date + If Date Is Within One Year
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.
Help Article Resources
Check out the Formula Handbook template!