Date comparison to same 'wednesday' of previous year
Been struggling with dates... again. And this could be a stupid question, so bear with me.
Today's issue is trying to compare the sales we did yesterday, (in my example lets say yesterday was Wednesday March 29, 2017), to one year ago (but the same wednesday, not simply 365 days ago as that would give me the wrong week day). In 2016 the Wednesday was March 30, 2016
I'm getting various dates for comparison like below:
Thanks for the direction