Hi all.
I need a format rule to highlight any date before TODAY() or within the next 7 days no further than that.
The date column is [WEC] so I have tried a few variations:
[WEC]>=TODAY()-7 which obviously highlights all dates greater than today - 7, I need to ignore dates > 7 days from TODAY()
Can anyone help with the expression please.
TIA
