Date Series in Excel 1

[ccjjscb]

I have an Excel spreadsheet that has data entered on Wednesdays and Saturdays only. What I need is a way to put the dates in for Wed. and Sat. and then drag the cells down to fill in the series so I have the dates filled in for just Wed. and Sat. all the way down the sheet. I have tried several ways and still no luck other than filling in each cell with the correct date one at a time. Any ideas if and how this can be done?
Thanks for any and all help.
Chris

 

[AnotherHiggins]

Start with 9/6/06 (or any Wednesday) in A1.

In A2, type in [COLOR=blue white]=A1+3[/color]

In A3, type in [COLOR=blue white]=A2+4[/color]

Select A2 and A3. Drag down.



[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[ccjjscb]

Thanks very much for the help, never even thought about a formula for the series.
Thanks
Chris