Date comparison to same 'wednesday' of previous year
Hi,
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:
I get it. Yes that would be the way I'll do it. Just wondered if there was something I may be missing/function somewhere.
Thanks for the direction
Ray Paseur
Going forward, you might want to think about leaving these questions open a little longer. There is a perfectly suitable solution to the one-year-ago problem. But that said, day-by-day sales reports are almost always too granular to be useful. What if it snowed on one of the days but was sunny and nice on the other? The potential for wide and uncontrolled short-term variability make month-over-month and quarter-over-quarter statistics, generally, more meaningful.
Thanks for the direction