formula needs to move across 1 column every week
 

Hi

I need some help, i have a simple formula that sums for example AA40:AG40.
Every week this has to increment across 1 column ie. AB40:AH40 in week 2

Currently i'm adjusting these formulas manually. Is there an easier way to
do this?

Thanks
edul

formula needs to move across 1 column every week
 

=SUM(OFFSET(AA$40,0,WEEKNUM(TODAY())-1,1,7))

--
Regards!
Stefi



€žedul€� ezt Ã*rta:

Hi

I need some help, i have a simple formula that sums for example AA40:AG40.
Every week this has to increment across 1 column ie. AB40:AH40 in week 2

Currently i'm adjusting these formulas manually. Is there an easier way to
do this?

Thanks
edul


.