Date format

[TD]

Hi,

In my download file i am getting date as "cyymmdd". for e.g. April 5, 07 i
am getting 1070405.

Is there any way (custome format, macro, function) i can convert it to
yy-mm-dd format?

 

[Vergel Adriano]

TD,

Assuming the date in "1"yymmdd format is in A1, and that you don't have to
deal with dates prior to 1/1/2000, try this formula in B1

=DATE(2000+MID(A1,2,2), MID(A1,4,2),RIGHT(A1,2))

 

[ward376]

This formula will return an actual date value for the cyymmdd format
including pre y2k. You can format it any way you like once you have
the value.

=IF(LEN(A1)=7,VALUE(CONCATENATE(MID(A1,4,2),"/",RIGHT(A1,2),"/",MID(A1,2,2))),VALUE(CONCATENATE(MID(A1,3,2),"/",RIGHT(A1,2),"/",LEFT(A1,2))))