Question: how to change year of date in excel?
Answer: 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.