If Formula

Mstockbridge

So I'm working on a formula I just can't get right...

I'm trying to track expiration dates, so.. Id like...

Status to be Yellow if it's 60 days from today

red went is 30 days from today and Passed the expiration dated

and green for 61 days + if that makes sense

Please help !!!!

Amber Eakin

Hello @Mstockbridge - I believe I have a formula to work for you. You'll need to change the [End Date] to whatever the "expiration date" column is named. Please try it and let me know.

=IF([End Date]@row > TODAY(+60), "Green", IF([End Date]@row > TODAY(+30), "Yellow", "Red"))