Excel problem

  sputnick 14:16 18 Oct 2007
Locked

I am having trouble configuring dates in Excel.
I need to make a column of dates increasing in two week increments.
Each year I make one and by the next time I have forgotten.
I have inserted the first two dates and dragged them but they only increase by one day.
I went into Edit, fill and tried different combinations.
I`ve just managed to do it once but can`t replicate what I did again.
Also is there a way to just update last years page.

  bstb3 14:38 18 Oct 2007

Hi Sputnick, not sure if this is what you meant or not (for example dates starting 1st Jan)?

01/01/07
15/01/07
29/01/07

If it is then in the first cell of your list type your starting date, then in the cell below use the formula =A1+14 (assuming you start in cell A1). Then just drag this formula down and the date will increase in two week (14 day) increments.

Hope this helps :)

  sputnick 14:51 18 Oct 2007

Thanks for that .
I`ll put it in a memo for next time.

  Chris the Ancient 15:11 18 Oct 2007

Remember the easier way...

Put the 1st date in one cell
Put the date of the next week in the next cell.
Highlight BOTH dates, and then drag down.

You can also use the Drop-down 'Edit/Fill' menu to create a series at any increments you desire.

CtA

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?