Easy Date Question: Today plus 30 but nothing in the past
This one should be easy but every iteration that I've tried is not working.
I would like the formula to first check the Expired column to see if it's checked, if it is, return "Closed", if it's not, check to see if it's today's date or 30 days out and if it is, return "Blue" (I would like to see any tasks that are within a month out but not worry about those that are done/expired).
I am using the following:
=IF(Expired@row = 1, "Closed", IF([Expire Date]@row <= TODAY(+30), "Blue"))
It's working but it's giving me anything that is past due (prior to today) as well. How do I get it to look forward but not back?
Help Article Resources
Check out the Formula Handbook template!