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.