Contract Expiry date less than 0,30,90,180 days from todays date apply RAG

Lee Rudd

I have a RAG dropdown column configured, a formula is required for the RAG to be applied against the following:

Expiry date 180 greater than todays date = Green

Expiry date is between 180 - 90 days greater than todays date = Yellow

Expiry date is between <0 - 60 days greater than todays date = Red

The Expiry date is a column and date formated.

SmartLew

hi @Lee Rudd

This gives you what you asked for;

=IF([expiry date]@row > TODAY(179), "Green", IF([expiry date]@row > TODAY(89), "Yellow", IF([expiry date]@row < TODAY(61), "Red")))

But what about if it is between 60 and 90?

SmartLew

hi @Lee Rudd

This gives you what you asked for;

=IF([expiry date]@row > TODAY(179), "Green", IF([expiry date]@row > TODAY(89), "Yellow", IF([expiry date]@row < TODAY(61), "Red")))

But what about if it is between 60 and 90?

Lee Rudd

Thank you, that works, I have altered the days to remove gaps. Appreciate your guidance.

SmartLew

Happy to help!