Extract Date from text

[Gregfox]

Hi all,
I have the following TEXT(not date format):

Stocks - Market value = $1,00.00* Tue Jan 30 2018 4:49:33 pm EDT in Cell A1 sheet 1

I wish to extract the date only to be 1/30/2018 in sheet 2 in cell B3

Note: the dates change like Feb 21 2017, Apr 4 2016 etc.


I tried the MID function after the '*' to no avail.

 

[Rick Rothstein]

Jeepers, I was kinda 'xpectin' ol' Rick ta say sumpin' 'bout the title of my message box -- but nuttin'.

I thought about it; but, given the wording you used, I could not figure out exactly how to respond to that.

 

[Gregfox]

Thank y'all