how to convert a column of numbers (monthdayyear) into dates?
Sorry, forgot the final case of the cell being anything other than containing
7 or 8 characters...........
=IF(LEN(A1)=8,DATE(RIGHT(A1,4),LEFT(A1,2),MID(A1,3 ,2)),IF(LEN(A1)=7,DATE(RIGHT(A1,4),LEFT(A1,1),MID( A1,2,2)),""))
Vaya con Dios,
Chuck, CABGx3
"CLR" wrote:
=IF(LEN(A1)=8,DATE(RIGHT(A1,4),LEFT(A1,2),MID(A1,3 ,2)),IF(LEN(A1)=7,DATE(RIGHT(A1,4),LEFT(A1,1),MID( A1,2,2))))
Vaya con Dios,
Chuck, CABGx3
"wsucougar" wrote:
At issue is some numbers are 7 digits and some 8 (ie 7012006 or 10012006).
None of my attempts resulted in excel recognizing as valid dates.
|