software

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.

quot;Denny Cranequot; gt; wrote in message
...
gt;I have a column that i want to populate with Friday of each and every wk of
gt; 2006. I would like to use the format: 17-Feb-06
gt;
gt; Thanks
gt; Denny
Put your first date in a cell, say A2
In the cell below, A3, use the formula

=a2 7

amp; copy it down as needed. Apply your desired formatting to all the cells
quot;Denny Cranequot; wrote:

gt; I have a column that i want to populate with Friday of each and every wk of
gt; 2006. I would like to use the format: 17-Feb-06
gt;
gt; Thanks
gt; 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
quot;Denny Cranequot; gt; wrote in message
...
gt;I have a column that i want to populate with Friday of each and every wk of
gt; 2006. I would like to use the format: 17-Feb-06
gt;
gt; Thanks
gt; Denny