Calculating the Week Number Corresponding with a Specific Date

How can I convert this date in excel
081906 - means 08 is the day - 19 is the week - 06 is the year. So in other words it means the 19th week of the year 2006 and the 08th day of that month. It reads May 8, 2006

How can I convert this date in excel
081906 - means 08 is the day - 19 is the week - 06 is the year. So in other words it means the 19th week of the year 2006 and the 08th day of that month. It reads May 8, 2006

Problem:

Calculating the week number corresponding with each of the dates listed in column A.

Solution:

Use the WEEKNUM function as shown in the following formula:
=WEEKNUM(A2,2)