Automatically update user-inputted date after specified time range
Hi all,
I have a column where the user inputs a date of client intake, and several conditional reminders across the row are based on that date.
After 12 months go by, I need the intake date to automatically update the year (but keep the day and month the same) so that a fresh set of conditional-highlighting reminders will be activated.
If it's possible to do that without macros, great, but I'm guessing I have to use a macro, perhaps each time the worksheet is opened? Unfortunately I don't know the first thing here. Is there a way to check the dates in the column and update any that are a year old? (for my purposes, the column is G and the dates begin in row 5--the other rows are headers and such)
(If it's easy to account for leap years, that's great--if not, I could just instruct users never to enter Feb 29 or create a data validation rule that prevents it)
Thank you in advance for any assistance you can provide. Happy holidays for anyone celebrating.
|