knew it was something simple.

given the above post the end formula is:

(A * B)-(A + C)

where
A = selected week
B = 8 (constant)
C = 2 (constant)

this gives me the StartRow and i add 8 to get the end row.