close

Ok I need to figure out how to show all of the fridays of this year in column
A. And i want the machien to do it.

ex.

3/31/2006
4/7/2006
4/14/2006
4/21/2006
.....and so on
Put the first date in one cell (A1), put the second date in another
consecutive cell (A2). Highlight both cells, move the pointer to the bottom
right of the selection and it will turn into a plus sign. Click, hold and
drag down until you get to where you want to stop and release the mouse,.
--
Hope this helps,
MarkNquot;Tannerquot; wrote:

gt; Ok I need to figure out how to show all of the fridays of this year in column
gt; A. And i want the machien to do it.
gt;
gt; ex.
gt;
gt; 3/31/2006
gt; 4/7/2006
gt; 4/14/2006
gt; 4/21/2006
gt; ....and so on
gt;
gt;

In A1 enter the date of the first Friday you're interested in, i.e. 3/31/06.

In A2, enter this formula:
=A1 7

Then copy down as far as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------y
quot;Tannerquot; gt; wrote in message
...
gt; Ok I need to figure out how to show all of the fridays of this year in
column
gt; A. And i want the machien to do it.
gt;
gt; ex.
gt;
gt; 3/31/2006
gt; 4/7/2006
gt; 4/14/2006
gt; 4/21/2006
gt; ....and so on
gt;
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()