VBA Code or Formula to Convert format of extracted Data

[Bpd]

I have VBA code the extracts data from a source and puts it into excel. I need to change the format of some of the extracted data so i can use it for a VLookup formula. Reference the attached example. Columns A AND B have the extraced data which are dates. In Columns C and D or E and F I have typed what I would like the data to look like so I can use in a Vloolup formula. Is there VBA or a formula that word change the format of the dates in Columns A and B to look like C and D or E and F. The changed format could be moved to any new cells or rows.

Thanks,
Brian

[Leith Ross]

Hello Bpd,

Here is a non VBA option. You can use formulas to convert the values to dates and then format the columns to display the dates in the format you want.

Cell C5 formula: =IF(A5="", "",DATEVALUE(REPLACE(REPLACE(A5,3,1,"/"),6,1,"/")))
Cell D5 formula: =IF(B5="","",DATEVALUE(REPLACE(REPLACE(REPLACE(B5,1,2,""),4,1,"/"),7,1,"/")))