How can I use variables in reference to external cell

[hendis]

TIA.

I have a LibO/Calc template that contains my company’s timesheet. I want to include last week’s hours on this week’s timesheetby putting a formula in the template.

I need to refer to last week’s timesheet (external reference), but since the W/E date is part of the filename, the name changes each week.

How can I obtain the “Total hours” value from a past LibO/Calc worksheet?

[mariosv]

You can create any reference with INDIRECT(a) function.
a: can be a text composing the link or a cell reference with the composed link as text.