Excel - Dynamic Ranges - Offset

0
votes

I'm struggling to get this to work.

Imagine something like this:

enter image description here

I need to make dynamic charts, using today as start day and count 7 days backwards (a week).

Under Name Manager (Define Name), I've tried to use offset,index, match and today() like this:

=OFFSET(INDEX(A:A;MATCH(TODAY();A:A));-1;0;-7;0)

No result for that formula.

Is this possible? Can I use Dynamic Ranges using dates?

1
excel

1 Answers

1
votes

The final parameter in the Offset function determines the width of the range, which you have specified as 0. You just need to change it to 1, and I would also lock the addresses for column A:

=OFFSET(INDEX($A:$A;MATCH(TODAY();$A:$A));-1;0;-7;1)

NB: Today's date also needs to be in the data