I am trying to figure out how to change the Year in date format so the year in different rows will reflect the same year on all dates so it can be alphabetise.
Example 5/12/2012 Joe Doe 1000 Drury Lane
7/12/2014 Lee Jone 1200 lee
8/15/2015 Mark Jones 1200 Dotsy
9/19/2016 Jame Drake 1500 Morgan
would like to change the years to 2018 in all dates above so the other columns with information can be alphabetize correctly instead it breaking them down into years and alphabetizing?
Results to show
5/12/2018 Joe Doe 1000 Drury Lane
7/12/2018 Lee Jone 1200 Lee
8/15/2018 Mark Jones 1200 Dotsy
9/19/2018 James Drake 1500 Morgan
Bookmarks