Hi Arvil,

That solution is really cool--thank you!

The only issue I have now, though, is that all of my conditional-highlighting reminders in the rest of the row point to the original column (the user-inputted date). So I actually need the date to update within the same cell rather than a new cell. I don't quite see how to apply your solution to the same cell (I'm still wondering if it will be necessary to use an event macro to achieve that?).

So let's say my user-inputted dates are in the G column, and one of those dates is June 7, 2019. That date should stay the same for 12 months. When the current day is June 7, 2020 (or after) and the user opens the worksheet, the date should automatically update to June 7, 2020 in the same cell. Then, all of my conditional-highlighting reminders will update for the user for the next 12 months. Then the date would automatically update again on June 7, 2021 (or whenever the user opens the worksheet on or after that date).

Please let me know if that needs further clarification, and thank you again for your time and expertise!.