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
Or convert a text of 080521 to a date format 05/21/08?
thx, k
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
V
vezerid
=DATE(--LEFT(A1,1+(LEN(A1)=6),--MID(A1,3,2),--RIGHT(A1,2))
HTH
Kostis Vezerides
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
=--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
=DATE(2000+(--LEFT(A1,1+(LEN(A1)=6))),--MID(A1,2+(LEN(A1)=6),2),--RIGHT(A1,2))
HTH,
Bernie
MS Excel MVP
V
vezerid
Right on Bernie, thanks for the pointer.
Regards,
Kostis
Regards,
Kostis
K
KKay
Thanks to all! worked like a charm...and saved me time.