I have a series of column headings which are used to describe a date period, however they are stored as a number.
PERIOD1 PERIOD2 PERIOD3 PERIOD4 PERIOD5 PERIOD6 PERIOD7 PERIOD8
9042011 9302011 10072011 11142011 11212011 11282011 12052011 12122011
PERIOD1 is Cell "F1" and the date range is "F2:BE2"
I need to convert these into a MS Date format. I am thinking that if I were to get the slash marks in the right spots (9/04/2011), the program will easily convert this into a date during a second import process. I thought that I might need to read the numbers and set them as temp variables tvDate = (4 characters from right), tvDay = (2 characters in mid) and tvMonth = (first 1 or 2 characters).
Then put all the temp values together again as a date formated "mm/dd/yyyy" and replace the field.
Any thoughts on this?