Hi All;
I am trying to compare (for example) Jan 2013 to Jan 2014 for each day of the week...Matching on Day of the week. That is Wed 1-8-14 to Tues 1-8-13. If I just use the 1-8-13 to 1-8-14 will only skew the numbers. Because 1-8-13 was on a Tues last year and 1-8-14 is on a Wed this year. I have to compare by the day of the week (Mon thru Sunday) . Also, the user does not want to consolidate all Mondays into one, Tues into one ...etc...they want Monday thru Sunday for each week in Jan.
Any ideas?
Thanks
Mike