automatically set up dates 2 weeks apart

  • Thread starter Thread starter William Storey II
  • Start date Start date
W

William Storey II

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,

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
 
Back
Top