convert 80521 to 05/21/08

K

KKay

Is there a formula that would convert 80521 to a date, 05/21/08?

Or convert a text of 080521 to a date format 05/21/08?

thx, k
 
V

vezerid

=DATE(--LEFT(A1,1+(LEN(A1)=6),--MID(A1,3,2),--RIGHT(A1,2))

HTH
Kostis Vezerides
 
R

Rick Rothstein \(MVP - VB\)

If all your dates will be on or after the year 2000, try this formula...

=--TEXT(A1,"2000-00-00")

Rick
 
B

Bernie Deitrick

You should be consistent, as well as keep the value in this century:

=DATE(2000+(--LEFT(A1,1+(LEN(A1)=6))),--MID(A1,2+(LEN(A1)=6),2),--RIGHT(A1,2))

HTH,
Bernie
MS Excel MVP
 

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

Problem formatting dates from CSV file 2
Count based on multiple criteria 2
Workday Formula to include date 0
SUMIF with date Question? - Maybe 5
vLookup with dates 17
Project a date and calculate a % in one formula 4
2 dimensional date sort 1
Count Function 2

Top