RAG status on dates

[New-here1]

Hello,

I have the following code:

if([End Date]<Today(),red,
if([End Date]>7,today() and [End date]<30,today(),amber,
if[End Date]>30,today,green

The first line to show everything in red that is today's dates or less
The second line to show everything in amber that is due end in 7 days or more but less than 30 days
The third line to show everything in green that is due to end in more than 30 days

The above isn't working for me and I'm not how why. Could someone help please?

Thank you

[MayilVahanan · Accepted solution]

Hi

Try like below

if([End Date]<Today(), redcolor, 

if([End Date]<Today() + 30 and [End Date]>Today() + 7, ambercolor,

if([End Date]>Today() + 30, greencolor)))

[New-here1]

This worked, thank you!