IF Functions and Dates
I am trying to use an IF function with dates. For example, IF a date is less than 15 days, return green, less than 30 days, return yellow and more than 30 days return red. When I tried typing this function in using the correct symbols and true/false values, I get an error message. I am creating a log of requests, but there is not a due date associated with the request, only the date the request was initiated. I'm trying to flag requests as green, yellow or red, if they are 15 days or newer (green), 16 - 30 days old (yellow) and more than 30 days old (red).
Is there a way to do this?
Help Article Resources
Check out the Formula Handbook template!