RGB Formula

Maria Watters

I am wanting my formula to turn yellow if the end date is between 3 and days away. How would I make that work?

IF(AND(Status@row = "In Progress", [End Date]@row > TODAY(-10), [End Date]@row < =TODAY(3))

L_123

IF(AND(Status@row = "In Progress", [End Date]@row < TODAY(10), [End Date]@row >=TODAY(3)),"Yellow"

You were fairly close, just a little mix-up on the signs

L_123

IF(AND(Status@row = "In Progress", [End Date]@row < TODAY(10), [End Date]@row >=TODAY(3)),"Yellow"

You were fairly close, just a little mix-up on the signs

Maria Watters

Thank you!