convert 80521 to 05/21/08
 

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

convert 80521 to 05/21/08
 

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

HTH
Kostis Vezerides

On Jul 3, 5:54 pm, KKay wrote:
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

convert 80521 to 05/21/08
 

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

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

Rick


"KKay" wrote in message
...
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

convert 80521 to 05/21/08
 

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


"vezerid" wrote in message
...
=DATE(--LEFT(A1,1+(LEN(A1)=6),--MID(A1,3,2),--RIGHT(A1,2))

HTH
Kostis Vezerides

On Jul 3, 5:54 pm, KKay wrote:
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

convert 80521 to 05/21/08
 

Right on Bernie, thanks for the pointer.

Regards,
Kostis

On Jul 3, 6:13 pm, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
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

"vezerid" wrote in message

...

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

HTH
Kostis Vezerides

On Jul 3, 5:54 pm, KKay wrote:
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

convert 80521 to 05/21/08
 

Thanks to all! worked like a charm...and saved me time.

"Rick Rothstein (MVP - VB)" wrote:

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

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

Rick


"KKay" wrote in message
...
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