Q:

Need to come up with an Excel 2010 equation

I imported data from a .txt file in a spreadsheet where the date of an actual data is 7/12/2011 but I have it as just 7/12 on .txt. After I changed the formatting in Excel 2010 I got 7/12/2013 instead because obviously Excel wouldn't know what year I have in mind. So, I want to come up with an equation that changes a year, 2013 to 2011. Please help how do I do it. 
Thanks a bunch!  

A:

You can do this:
=DATE(2011, MONTH(A1), DAY(A1))

