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

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.

"Denny Crane" wrote in message
...
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

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



"Denny Crane" wrote:

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

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



"Denny Crane" wrote in message
...
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