Hi.
I have a problem with the date data I'm receiving. Some of the dates have years from the 1900's when they all should be 2000's. What I'm trying to do to fix this is break the date column ("E:E") apart into different helper columns, split the year into two parts([19 & 37] or [20 & 12] for example), then replace all of the "19's" with "20's"- then concatenate the dates back together.
I'm trying to do this by looping through each worksheet in my workbook and doing all of the concatenations and separations using .formula.
I think I'm in over my head. This is what I've so far: The date column is originally in Column ("E:E") and I'm inserting three helper columns to the right of ("E:E"), making the date column eventually be H:H. I'll delete ("E:G") after I've created the new, fixed dates, in ("H:H").
Can any one help me out here?
Any help is greatly appreciated
(Edit) I've attached a sample problem as per suggestion. I'm also going to try adding to the 1900 number dates.
Bookmarks