how to change year of date in excel?
['Highlight the column where the dates are, then under the Home Tab, go to "Find & Select", then click "Replace"', 'Type "2014" under Find What, then type "2010" under Replace With.', 'Click Replace All.']