Dear all,
I'm using the namemanager function to create a dynamic xaxis for a chart which I have to update every week.
The following formula used to work:
=OFFSET('sheet1'!$G$14;MATCH('sheet1'!$G$14;'sheet1'!$G$14:$G$378;0)-1;0;MATCH('sheet2'!$L$11;'sheet1'!$G$14:$G$378;0)-MATCH('sheet1'!$G$14;'sheet1'!$G$14;0)+1;1)
in sheet 1 in column G dates have been put in for 2019; G14 = 1/1/2019; G15=2/1/2019; .. etc
in sheet 2 in cell L11 the end date is given; e.g. today the value would be 12/6/2019.
The output range of the OFFSET function should then be a range from G14 (1/1/0/2019) until G176 (12/6/2019)
If I put the formula in a random cell in the workbook the desired range (G14:G176) is selected. However if I put the formula in the refers to box of a new name in the namemanager function nothing happens.
I hope somebody is able to help,
Best regards,
Lucas
Bookmarks