I have two input dates on Sheet 2 (Sheet8 in attached file); Start, End. I have a list of dates on Sheet 1 (Called Calculations in file) and a named list which is a dynamic range of these dates, call it Date_Full = OFFSET(Sheet1!$A$4,0,0,COUNTA(Sheet1!$A:$A)-1). This is a sequential list of dates.
I have a couple issues when I create a named list called Date_Partial = OFFSET(Sheet1!$A$3,MATCH(Sheet1!Start,Date_Full,0),0,Sheet2!End-Sheet2!Start+1). Sometimes when I select it in the List Editor it highlights the right range, and other times it does nothing. Very spotty.
Now, for this last task I'm want to move Date_Partial over columns to select data, for example Data_1 = OFFSET(Date_Partial,0,3). This doesn't work whatsoever.
Have I stacked too many OFFSETs together? Any thoughts on what is going on, or how to correct this issue?
Thanks.
EDIT: I attached the actual spreadsheet, if that helps. It isn't finished, but I think it's awesome so anyone that counts calories might be interested in it.
Bookmarks