Same Date Last 1/2/3 Year(s) Ago
I need to calculate the same day of the week from a prior year to compare the revenue generated on those days... Is this simply a matter of Date-364, Date-728, Date-1092, etc, etc? I would effectively want to compare the same Monday's vs Monday's, Tuesday's vs Tuesday's, etc.
Theoretically, this makes sense to me, but comparing the WeekOfYear, it seems to break down, the further back I would go.
Hoping somebody has some thoughts or advice on this.
Thanks in advance!