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)
Bookmarks