hello folks,
I have a column of data that has mostly dates in it. however, some rows have dates with the format "09/02/2014 as of 09/01/2014". all other rows have a normal date in format "09/12/2014". I'd like to run through all the rows and check for the odd format and change it so that it reflects the first date shown. for example, the odd format "09/02/2014 as of 09/01/2014" would become "09/02/2014". all other column entries would have no change. this would be in VBA. I'm thinking some type of loop that uses the frequently seen LR variable to determine how many rows there are and some algorithm to correct the dates.
thoughts?
thank you for the help.
Bookmarks