Date
 

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

Date
 

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 down


Arvi Laanemets


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

Date
 

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 fill


"dlw" wrote:

you can enter the first two dates, highlight them, then use the "fill handle"
to pull down the rest.

"Boenerge" wrote:

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