converting julian dates

[Guest]

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

 

[Guest]

=DATE(2000+VALUE(MID(A1,2,2)),VALUE(MID(A1,4,2)),VALUE(LEFT(A1,1))+VALUE(RIGHT(A1,2)))
--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.