How to autofill and autodelete formulas in google spreadsheets or excel?

Question

excel

Tell me how to make the formulas fill in automatically when the number of required lines changes:

Here is the file in google spreadsheets https://docs.google.com/spreadsheets/d/1xg73EBG7P8...
The final task is to generate a report for each day from one date to another date. I understood how to generate strings, but I don’t understand how to deal with formulas ...

Answer 1

File - Options - Advanced - Extend formats and formulas in data ranges

Question on the forum PE .
Updated on 01/13/2022
Formula for C5:

=ARRAYFORMULA(ДВССЫЛ("A5:A"&(B$1+4))*ДВССЫЛ("B5:B"&(B$1+4)))

+4 - how many lines the cell with the formula lags behind the cell with the specified number of lines.