HELP:Automate Status for Range of Dates

KandiceKnoelk

I am trying to construct a formula that will make the status turn yellow when TODAY() is 4 days to and 4 days after the date in the [Due Date] column.

I was hoping the following would work but it does not:

=IF([Due Date]8 <> TODAY(4), "Yellow")

 

Any ideas on how to write an if formula to cover the date range?

 

L_123

=IF(AND([Due Date]@row< TODAY(4), [Due Date]@row> TODAY(-4)), "Yellow")

I think that is what you are looking for

KandiceKnoelk

Thank you!