I have a report that I need to add up the total shipped for each of the last 4 weeks. It needs to be based on full weeks and not dependent on which day of the week the report is run. This report also includes a cross tab that gives me the total shipped for the year based on a starting date. Eventually I will also need to add in another cross tab to give me the total shipped qty for the prior year (also based on a begin date and end date).

Any suggestions on how to get the weekly total for each of the last 4 weeks? And possibly what formula to get the correct dates for the prior year cross tab?

Thank you in advance for your help.

My 2014 year starts on 12-29-13 (full week starting on Sunday)The end of the year will end up being short (ending on 12-27-14-Saturday)