Populating a column with calender dates............

D

Denny Crane

I have a column that i want to populate with Friday of each and every wk of
2006. I would like to use the format: 17-Feb-06

Thanks
Denny
 
G

Guest

Hi

Type the first date (06/01/06) into your first cell (say A2). In your second
cell type =A2+7 (assuming your first cell is A2) and fill this down the
column using the autofill handle (dragging the little black box in the
bottom right-hand corner of the cell). Job done!
You can format it however you like - either before or after the event.

Andy.
 
D

Duke Carey

Put your first date in a cell, say A2
In the cell below, A3, use the formula

=a2+7

& copy it down as needed. Apply your desired formatting to all the cells
 
B

Beege

Denny,
Start with first date in first cell (formatted accrdingly)
Select, say, 52 cells down, including the date
Edit/Fill/Series/ Step 7

HTH

Beege
 
Top