HELP:Automate Status for Range of Dates

KandiceKnoelk · 07/09/18

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 · 07/09/18

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

I think that is what you are looking for

KandiceKnoelk · 12/14/18

Thank you!

HELP:Automate Status for Range of Dates

Comments

Help Article Resources

Categories