I referred to the previously posted comments and solutions and it returned an error:

I am trying to extract the date from a few cells in excel as follows:

from
Promotion 10/08/10 Free - E2
Requested 12/20/10 - G2

to
10/08/10 - F2
12/20/10 - G2

Please help!

Thanks!