Get Data Excwl table causes system date changes

Never mind .

=DATEVALUE(IF(LEN(A7809)=8,(LEFT(A7809,2)&"-"&IF(MID(A7809,3,3)="jly","jul",MID(A7809,3,3))&"-20"&MID(A7809,6,2)),(LEFT(A7809,1)&"-"&IF(MID(A7809,2,3)="jly","jul",MID(A7809,2,3))&"-20"&MID(A7809,5,2))))

asHley85e

After converting to a date structure using Datevalue and are still having issues, add a new column and use = to refer to the Datevalue column. I also Data type as Long Date (I did this to insure no confusion with 2 digit years- '2014 for '14- if there was a problem there it's avoided). After that I converted the table to CSV file to enforce all the assigned data types- When dealing with huge databases I really dont want to revisit this issue!!

Example

Column AA has the date value formula                  Column AB references AA

(Datevalue formula)                                                  =AA

asHley95e