u/Alrakana

​

I have different dates typed from D5 to D31. I want those cells to automatically highlight a year later, but within a 30 day time frame. That is 15 days prior and 15 days after the date. For example, if the date is 5/15/25, I want it to highlight from 5/1/26 and 5/30/26.

Essentially, I want a one month grace period to reach the actual due date, which is exactly a year from the date typed in the D column.