Date Shifting

Hi All,

Attached is the workbook for reference.  Note problem I am having has been replicated using dummy data for privacy reasons.

Basically, what I have done (see Dashboard1 and Sheet 2 and 3) is visually align the Profits from each day to the previous day, and display the Sales only for Dec 31 2019. 

What I would like to do is do what I have done in Dashboard 1 (and Sheets 2/3) all in 1 sheet for visual appeal.

I have attempted to do this in sheet 1, but the issue is that I am unable to properly shift the profit of each day to correspond to the previous day.

I hope this all makes sense!

Also, on a side note but not super important, does anyone know how to get a single date calendar filter (see sheet 4)

Any help is appreciated!

Aidan