Need a Date Formula

[spisales]

I want to be able to enter a date in Column A and then have columns B,C,D,E, & F autofill to a certain assigned date.

So for example
Cloumn A 7/28/2011
Coulmn B 7/29/2011
Column C 8/4/2011
Column D 8/11/2011
Column E 8/18/2011
Column F 8/25/2011

Thanks for your help

 

[wigi]

What is the relation between the dates in columns A and B?
The other dates are always 1 week after the previous one?

 

[spisales]

I need to put together a spreadsheet for a marketing campaign and the first few touches are spaced out over a few days then it goes to 1 week increments.

 

[wigi]

How do you decide what dates should be in the columns?

If you can't define that logic, no formula or VBA code will do it for you automatically, and you will end up with manual entry.

 

[spisales]

Good point.....so I guess the columns could be labled touch #1, touch #2, etc....

Thanks for helping

 

[wigi]

The labels or titles are less important, it's the logic to define the formulas...