Could someone help me with a "complex" date calcuation

[iki]

Hi, I currently am looking at a huge excel file with thousands of dates in the following format: 1060614 indicating 2006 June 14th.

I am looking for a formula or set of formula that can change that number into 3 categories 1) Year 2) month 3) week. The third one will be tricky in that my data spans from 2005-2008 current date. I need to organize every entry in one week increments, so that I will have the following:

DATE YEAR MONTH WEEK

1060614 2008 June 78
1060615 2008 June 78

Any help you can give me would be greatly appreciated

Thanks again,
iki

[Bob Phillips]

B1: =--(20&MID(A1,2,2))
C1: =TEXT(MID(A1,4,2)&"-"&B1,"mmmm")
D1: =INT((DATE(B1,MID(A1,4,2),RIGHT(A1,2))-DATE(2005,1,1))/7)+1

[iki]

B1: =--(20&MID(A1,2,2))
C1: =TEXT(MID(A1,4,2)&"-"&B1,"mmmm")
D1: =INT((DATE(B1,MID(A1,4,2),RIGHT(A1,2))-DATE(2005,1,1))/7)+1

Thank you so much that worked perfectly.

:) once again you guys are life savers