Convert 1208 to 12/2008 date

  • Thread starter Thread starter Gemi
  • Start date Start date
G

Gemi

I have a file that stored dates by month /year. Is there a formula to chagne
the numbers to dates? I tried in format cells but it does not work. I need
1208 to read as 12/2008 and 408 to read as 4/08. Thanks for your help!

Lee
 
=DATE(2000+RIGHT(A1,2),LEFT(A1,LEN(A1)-2),1)
and format m/yy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return Month & Year of Date Value 1
FORMULA NEEDED FOR MONTHS 1
SUMIF Formula Help 8
Calculation of future dates 2
Date time format to date only 4
formula help 5
Summarizing Dates into Months and Years 8
Excel Jululian 5

Back
Top