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

@Justalex_BTW 

In the Conditional Formatting dialog, 

mathetes_0-1713892719103.png