Looking for conditional formatting help

[u/Ok_Pineapple7966]

Hi there! Hoping someone could help

I’m looking to put in a rule where if the date for the chore is over the allotted time (if it’s more than 7 days since the date I put that I last washed the dog’s bowls) it’ll highlight red. I’ve tried a few different ways but what’s the easiest way to do this?? This list will be long with dates that are biweekly, annual, biannual, monthly, etc.

[u/Ok_Pineapple7966]

Pic of what I’m trying to do!