Thread: Really challenging problem

I am currently working at a non-profit org and they have asked me to calculate feedback for every week since 7/5/2010. They use a program call Fogbugz which uses some coding. I was wondering if there was a way to manipulate excel to help me do this:

"Re: Archive" area:"My Posted Project" opened:"7-5-2010..7-11-2010"
"Re: Archive" area:"My Posted Project" opened:"7-12-2010..7-18-2010"
"Re: Archive" area:"My Posted Project" opened:"7-19-2010..7-25-2010"

all the way until today (each are a week increment)

Essentially i need every line to have:

"Re: Archive" area:"My Posted Project" opened: the week range WITH the two periods in between the weeks"

I want excel to automatically change the weeks in the formula when I drag down and keep the ".." as a delimiter. In other words, I want to maintain the code but create weekly increments automatically
Any ideas?