So I've noticed in a worksheet I have many dates that are four years off, no doubt because of improper copy/paste from earlier question.
Is there an easy way to convert a bunch of dates I select to a specific year, but keep the month and day the same? For example, I'd like to quickly convert these cells:
6/1/2014
6/5/2014
7/18/2014
to
6/1/2010
6/5/2010
7/18/2010
There are hundreds of these, so I'd rather not do it manually.