Month to Date over prior and Week to Date over prior automation

Hello.

I am currently using formulas to calculate % change for week-to-date / prior week-to-date numbers and month-to-date / prior month-to-date.

This data is updated daily and requires me to manually adjust the days.

Is there a way to automatically calculate as new data is added each day? I've attached example file.