2 followers Follow

Find formula for a date range between today and the next 7 days in conditional formatting


I'm trying to set conditional formatting to our work logs. I want to highlight the dates that are due today or within the next 7 days.

How can I include this in a formula? 

I've found the opposite way (due date within last week) in the basic formulas, but not for the next 7 days. Is there a way to do this?

Julia Answered

Please sign in to leave a comment.

1 comment