Populate are offseted range with array formula

Hi

I have a problem that frequently occurs. I need to populate a range with an offset. In the attached workbook I need to populate the "Nominal" amount in A8 to reflect below 30/6/2023 to 30/9/2026. The array formula must be in D8. I can controll the ending column in the range using sequence function, is there a way to it with the starting column. The first "empty " columns can be 0.

Regards