i want to be able to make the date in a cell be two weeks difference(14 days
exactly) from the cell above it how would i do this ?

say that cell A1 contains a date 18/11/03 (I'm in Australia so we use
dd/mm/yyyy) and you want cell A2 to be equal to that plus 14 days, ie
2/12/03.

In cell A2 type =A1+14

HTH,
katherine

"William Storey II" <(E-Mail Removed)> wrote in message
news:Pgcub.32129$(E-Mail Removed)...
> i want to be able to make the date in a cell be two weeks difference(14
days
> exactly) from the cell above it how would i do this ?
>
>

William,

Two ways,

In A1 enter the first date. Select column A as far down as you need and make sure that A1 is the active cell. Then do Edit>Fill>Series and enter 14 as the step value.

Another way is to enter the first date in A1 and the second date in A2. Then select A1:A2 and fill down on A2 as far as needed.

HTH
Anders Silvén


"William Storey II" <(E-Mail Removed)> skrev i meddelandet news:Pgcub.32129$(E-Mail Removed)...
> i want to be able to make the date in a cell be two weeks difference(14 days
> exactly) from the cell above it how would i do this ?
>
>