Hi All!

Hoping someone can help me with this problem. What I want to do is
define a Scoped Project Week which won't or doesn't necessarily follow
a calendar week. Our qa projects are of short duration, 6 to 10 weeks,
so our week 1 could be any week in a calendar year. This is part of
an Excel template the entire team will use, the data is exported data
from Access (which I know very little about). The weeks are needed to
chart inflow/outflow of defects for a dashboard summary.
EX:
Col A B G H
Start Date End Date Start Proj Week End Proj Week
9/1/2006 9/10/2006 Week1 Week2
9/13/2006 9/20/2006 Week2 Week3
9/20/2006 9/20/2006 Week3 Week3
9/30/2006 10/16/2006 Week4 Week6


Using the function from Chip P. web site (TY Chip) I managed to get
this far, but am limited by the 7 nested If statements:

=IF(TRUNC(((Start_Date-DATE(YEAR(Start_Date),1,0))+6)/7)<=36,"Week1") -
For some reason I have to start with this function in Cell G2 to
start., not sure why.
=IF(TRUNC(((Start_Date-DATE(YEAR(Start_Date),1,0))+6)/7)=36,"Week1",IF(TRUNC(((Start_Date-DATE(YEAR(Start_Date),1,0))+6)/7)=37,"Week2",IF(TRUNC(((Start_Date-DATE(YEAR(Start_Date),1,0))+6)/7)=38,"Week3",IF(TRUNC(((Start_Date-DATE(YEAR(Start_Date),1,0))+6)/7)=39,"Week4",IF(TRUNC(((Start_Date-DATE(YEAR(Start_Date),1,0))+6)/7)=40,"Week5")))))

=IF(TRUNC(((Start_Date-DATE(YEAR(Start_Date),1,0))+6)/7)=41,"Week6",IF(TRUNC(((Start_Date-DATE(YEAR(Start_Date),1,0))+6)/7)=42,"Week7",IF(TRUNC(((Start_Date-DATE(YEAR(Start_Date),1,0))+6)/7)=43,"Week8",IF(TRUNC(((Start_Date-DATE(YEAR(Start_Date),1,0))+6)/7)=44,"Week9",IF(TRUNC(((Start_Date-DATE(YEAR(Start_Date),1,0))+6)/7)=45,"Week10")))))

Is there an easier way to write it without using nested IF statements
to cover the entire 10 to 12 week project?

Thank you in advance!