How do I change the dates in Excel for the below scenario:
Existing dates: 2/2/2014 3/12/2014 1/1/2015 2/1/2015 Target converted dates: 3/31/2016 3/31/2016 1/1/2016 2/1/2016
I want all the dates with 2014 (no matter what month and day) year to be a standard date 3/31/2016 and all the dates with 2015 year to add an additional year to their exact date and month.
Note: There are other columns (such as Name and Phone number) pointing to these corresponding dates. I don't want to lose the current sorting of the Excel sheet.
Can someone help me with this?