Comparing year over year data- by same week day
I want to compare the sales volume for 2020 against that of 2019 on a by day basis.
For example: 1st Feb, 2019 was a Friday and 1st Feb 2020 was a Saturday. Instead of comparing Feb 1, 2020 against Feb 1, 2019, I want compare Feb 1, 2020 against the nearest Saturday in Feb 2019.
Has anyone faced this scenario before. Please suggest.