Defect Aging Report in Excel 2010

Appreciate if the Excel gurus can help me with this Aging Report.

I need to create a defect Summary Report, where I can group the Open defects by 'Week' based on the 'Created date'.

The Categorization I want is in the lines of ..

<7 days -- 0 Weeks
>= 7 days --- 1 Week
>7 and <=14 days -- 2 Weeks
>14 and <=21 days -- 3 Weeks.. and so on... upto 15 Weeks

Is there an easy way to accomplish this in Excel ? Any specific formulas that can undertake this task smoothly ?

I'm attaching the file for your perusal. Thanks

Hi,

Try this where your age is in F2.

=CHOOSE(IF(F2<7,1,IF(F2=7,2,ROUNDUP(F2/7,0)+1)),0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15)

HTH
Steve

hi Steve,

Thanks for the quick one.. The condition when F2 < 7 returns #Value..

I've tried my best, but couldn't debug.. Appreciate your help.. thanks