I'm not sure where to start with this. I want to create a column in Excel that will essentially simplify another column. I have a column of dates with month, day, year, and a time. I want to use a formula to search for the year and then output that year into a new column. I am using Excel 2013 for this.
Something like IF(ISNUMBER(SEARCH("%2011%,A1)), "2011", "??").
Except I'd like the formula to be able to incorporate outputting 2011, 2012, 2013, 2014, 2015, or 2016 if that year is found instead.
Where do I start on this? is it even possible?