Mr. Shmuel, Thank you so much for your reply! Your help is appreciated! I've tried with your code then changed "text" to "Annual_Report_Year," But the result displayed only APR 2016, still in text form... The date (APR 2016) under Annual_Report_Year is literal text, not shortened variable from actual date, so no day of the month either... My goal is to convert all the literal date to numerical date, APR 2016 to 201604, so I could sort my combined data sets in the right annual order. So maybe I need to try another way to convert it? I attached my test file for your reference, thank you again!   ... View more

Mr. Bremser, Thank you so much for your reply! I really appreciate your help!! However, it did not work out...the result is blank... I don't know where I did wrong... I attached my test file for your reference! The date under Annual_Report_Year is literal text, not shortened variable from actual date... Thank you again! ... View more