iki
11-20-2008, 12:18 PM
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
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