Date Ranges and Pulling Data

ggjer 

I'd suggest you to reconsider the data structuring, more exactly use table as

               Quantity  Price Sales

Jan 1        100          $1      

Jan 2        110          $1

Jan 3         120          $2

...

Sales will be calculated. Same with other fields. With that you may build reports using PivotTable or formulas relatively easy. Otherwise that's not simple task and in any case you need to do such transformation in background to generate reports.

For already existing data that's one time job to transpose the data, could be done by formula or Power Query. In any case it's better if you provide sample file, otherwise someone shall make some guesses and assumptions (e.g. Jan 1 is text or date formatted as this), build the model and play with formulas. Without the file much less chances to have an answer plus assumptions could be wrong.