software

Is it possible to set up a function that will insert dates in 1 week
increments in a spreadsheet from a given date e.g.
insert:
01/01/01
then following dates down the column are inserted as follows:
08/01/01
15/01/01
22/01/01
29/01/01
etc.
Thanks for help in advance

When a formula is needed, then (in my example dates start from A1, otherwise
you have to modify it)
A1 -enter start date
A2=A1 7
and copy downArvi Laanemetsquot;Boenergequot; gt; wrote in message
...
gt; Is it possible to set up a function that will insert dates in 1 week
gt; increments in a spreadsheet from a given date e.g.
gt; insert:
gt; 01/01/01
gt; then following dates down the column are inserted as follows:
gt; 08/01/01
gt; 15/01/01
gt; 22/01/01
gt; 29/01/01
gt; etc.
gt; Thanks for help in advance
or you could have this formula in every row below the one your initial date
is in

assuming your start date is in a2
in a3 enter,,,,,,, =a2 7
in a4 enter,,,,,,, =a3 7

ect
ect

then every time you change the start date the others will auto fillquot;dlwquot; wrote:

gt; you can enter the first two dates, highlight them, then use the quot;fill handlequot;
gt; to pull down the rest.
gt;
gt; quot;Boenergequot; wrote:
gt;
gt; gt; Is it possible to set up a function that will insert dates in 1 week
gt; gt; increments in a spreadsheet from a given date e.g.
gt; gt; insert:
gt; gt; 01/01/01
gt; gt; then following dates down the column are inserted as follows:
gt; gt; 08/01/01
gt; gt; 15/01/01
gt; gt; 22/01/01
gt; gt; 29/01/01
gt; gt; etc.
gt; gt; Thanks for help in advance