Dynamic chart - Select the Last (-1 row) n date

[Villalobos]

Hello,

I would like to ask some help regarding dynamic charting.
In the sample file I would like to define a formula to select the Last (-1 row) n date but I cannot figure out.
The blocking points for me:
- the DATE cell contains formula,
- the range selection should start at Last (-1 row) n date.

The details in the attached file.

Thank you in advance the reply!