Conditional formatting when Event date is in a next 7 days

[vflorian19]

Hi All,

I would like to change the color of a date (event date) when it is in the next 7 days. I just can’t figure it how to phrase the condition. Can someone help me with this? Or just pointing me to the right direction?
Thanks a lot.

Florian

[yusaney1]

Hello @vflorian19.
You can subtract from the event date -7 days and then compare it with the current date to return true or not.

Example:

Redu.

[vflorian19]

Hi,

Hm i was wondering why there is only a +(days) option and no -(days), but of course the value can be negative as well Clear. Big thanks