Format Rule - Formula to Highlight date range

Hi All,

I would like to color text based on a date range in our App. I can get the items to highlight in the App based on the formula for a specific date example - [Next Test Due]=Today()+21

This highlights with the color on that specific date.

What would be the formula to put a date range between 1 & 21 days of my required test date to highlight that the item is coming up due for test in the next 21 days.

Thanks Dean.

Hi @Dean_Manning,

Could you please try an expression something like

AND( [Next Test Due]>=TODAY(), [Next Test Due]<=(TODAY()+ 21))


Ripper that’s the one I needed @Suvrutt_Gurjar

Works perfectly.

Thanks Dean.