Rule to have cell value (date) change formatting based on today's date

Copper Contributor

What would the formula be to change a cell's formatting based on if the cell value (date) is between 14 days before the value and 30 days after the value?

1 Reply


In the Conditional Formatting dialog,