I need to increase show the date range by 7 days showing the month end date.
The date need to look like this
11-Nov-12 18-Nov-12 25-Nov-12 30-Nov-12 2-Dec-12 9-Dec-12 16-Dec-12 23-Dec-12 30-Dec-12 31-Dec-12 6-Jan-13

The formula i created calculates month end date but the futuristic dates are based off the month end date instead of the date present prior to the week of month end.

Thanks as usual