Conditional formatting when Event date is in a next 7 days

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.


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



1 Like


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

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.