witzph1
asked on
Advance Selected Date Cells One Year
I have a spreadsheet which has a column of dates. I would like to be able to select certain of those cells and click a button to have the year of the selected cells advance one year. So for example, the two cells selected like this:
...would be like this after clicking the macro button:
I know how to add a year using a formula, but am not sure how to do it in a macro for selected cells. Your help would be much appreciated!
advance-1-year.xlsx
...would be like this after clicking the macro button:
I know how to add a year using a formula, but am not sure how to do it in a macro for selected cells. Your help would be much appreciated!
advance-1-year.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome and I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
ASKER