CODEWITHSUNDEEP
excel
Pedro Almeida
Pedro Almeida

Reputation: 45

Excel - Dynamic Ranges - Offset

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?

Upvotes: 0

Views: 130

Answers (1)

Dave
Dave

Reputation: 1643

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

Upvotes: 1

Related Questions