Calculation between two tables using max date

I have two tables below.  I am trying to create a calculated column BY STORE for the previous 43 days.  However, typically Table 2 is always one day behind so I'd like for it to go back 43 days of wh...