I have a report due that needs to compare the same day of week this year to that of last year. So where before I would compare 1 March 2019 to 1 March 2018, I now need to compare the same day of week last year.
So if 1 March 2019 was a Friday, then I need to compare it to the previous years 2 MArch which would be the friday. Does that make sense? The activity is not necessarily based on day of the month, but on day of the week in the month, so the first Monday of the month this year compared to the first Monday of the month last year etc.
This would give me the same date last year, not the same day of the week last year.
1 March 2019 was a Friday, 1 MArch 2018 was a saturday (for example). I cant compare activity from a friday to a saturday. I need to compare this 1 MArch 2019 (Friday) to the year before that Friday. So if the year before that was a saturday, then I need to go back to the first Friday before 1 March 2018. Make sense?