converting julian dates

D

Dvelasq

I have a date format that I can not convert to calandar dates;

the dates in column a

1060417

anybody know what I should use to convert to
04/18/06
 
G

Gary Brown

=DATE(2000+VALUE(MID(A1,2,2)),VALUE(MID(A1,4,2)),VALUE(LEFT(A1,1))+VALUE(RIGHT(A1,2)))
--
HTH,
Gary Brown
[email protected]
If this post was helpful to you, please select ''YES'' at the bottom of the
post.
 
Top