Replacating successive dates a week at a time?

J

JER

My work week starts on Tuesday. I would like to have my worksheet show
column A-1 row starting with the date 05/25/04, the A-2 cell immediately
below it 06/01/04 and so on. Can I replicate this with out having to type
the date for each successive Tuesday through the year?

With appreciation

Jerry (newbie to Excel)
 
D

Domenic

Hi Jerry,

Assuming,

A1=05/25/04

Put this formula in A2 and copy it down as far as you need to:

=A1+7

Hope this helps!
 
G

Gord Dibben

JER

In A1 enter the date 05/25/04

In A2 enter =A1 + 7

Drag/copy down as far as you want.

To drag/copy down, hover the mouse pointer over the lower right corner of A1.

You will see a black lump and the pointer will change to a cross. Left-click
and drag down Cplumn A.

Gord Dibben Excel MVP
 
Top