how to convert a column of numbers (monthdayyear) into dates?
Hi,
try it
=if(len(b2)=7,date(right(b2,4),left(b2,1),mid(b2,2 ,2)),date(right(b2,4),left(b2,2),mid(b2,3,2)))
hth
regards from Brazil
Marcelo
"wsucougar" escreveu:
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.
|