Copy Date from Cell

**sam.valanju** · 09-10-2012, 03:24 AM

Hi,

I need VBA code that will copy date from a cell.

For eg., Cell has value like - "Sam_Valanju 03/21/1988" then only date should be copied to another cell i.e. 03/21/1988

**arlu1201** · 09-10-2012, 04:14 AM

Do you have a few samples that you can provide?

**sam.valanju** · 09-10-2012, 05:13 AM

Yes,

Below are the smples that you could copy in excel cells for investigation -

E54321 10/7/2012 Order as Unit 1
Lat321 10/9/2012
E54321 9/13/2012
Sam_Valanju 03/21/1988

**arlu1201** · 09-10-2012, 05:24 AM

Tom,

I tried your formula too, but i guess the last digit should be 10 and not 9 like this =TRIM(MID(A2,FIND("/",A2)-2,10))

If its 9, it does not show the full year for the last 2 rows.