Converting Text Date format to MM?DD?YY Format

Hi All at Excel Forum,

I am still using Excel 2003

See attached Excel Spreadsheet "FT NEW DATES"

The dates in cells B37:B46 are as"TEXT"

In cells C37:C46 I would like to display the dates in the numeric format MM/DD/YY
using Vlookup sing cells P3:Q15 Table

Thank you for your help inadvance
Best regards,
Derek
........................................................................................



Friday, July 22, 2016 Display Cell B37 as MM/DD/YY
Thursday, July 21, 2016 Display Cell B38 as MM/DD/YY
Wednesday, July 20, 2016 Display Cell B97 as MM/DD/YY
Tuesday, July 19, 2016 Display Cell B40 as MM/DD/YY
Monday, July 18, 2016 Display Cell B41 as MM/DD/YY
Friday, July 15, 2016 Display Cell B42 as MM/DD/YY
Thursday, July 14, 2016 Display Cell B43 as MM/DD/YY
Wednesday, July 13, 2016 Display Cell B44 as MM/DD/YY
Tuesday, July 12, 2016 Display Cell B45 as MM/DD/YY
Monday, July 11, 2016 Display Cell B46 as MM/DD/YY

Year ,=RIGHT(B37,4)
Month ,=LEFT(RIGHT(B37,13),3)
Day ,=LEFT(RIGHT(B37,8),2)

Hi Mr Topley,

Thank you very much for your help, you have sent me a very clever solution to my problem
You have use some Excel terms which are new to me.
I take it that your Waterlooville is in Hampshire

Kind regards,
Derek

Yes ... it is Waterlooville, Hampshire although I am a Northern "lad" (from Keswick)

If your problem has been solved could you mark the the thread as such ("Thread Tools" at top of first post).