Author Topic: Custom rolling 8 weeks  (Read 5660 times)

Offline cfsindorf

  • Full Member
  • ***
  • Join Date: Nov 2009
  • Posts: 13
  • Forum Citizenship: +0/-0
Custom rolling 8 weeks
« on: 29 Apr 2013 08:17:08 am »
I need to create a custom rolling 8weeks based on the most receint date in a column.  Then group from there in 7 day groupings.

so:
current day 4/29
week eight 4/23-4/29
week 7 4/16-4/22
week 6 4/9-4/15
etc

so if i go to the week level i would see
4/29
4/22
4/15

then day under 4/29 would show me 4/23 - 4/29

Thanks