Results 1 to 5 of 5
  1. #1
    Join Date
    May 2006
    Posts
    178

    Unanswered: sequencing cells when draging dates?

    Hi Guys,

    Im dragging a cell that contains a date howevewr instead of incrementing the date it increments the year

    ie.

    ----------1-----------2-----------3-----------4
    A----21/08/06------21/08/07---21/08/08

    B

    C

    Ive tried entering 2 dates then dragging across but i still get the same problem.

    Any ideas?

    Thanks

    Aboo

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    You have to enter at least two dates for Excel to know the pattern to increase.

    In A1 put:

    21/08/2006

    In B1 put:

    22/08/2006

    Now select both cells then drag to the right (I assume you are moving the cursor to the lower right of last of the selected cells and when it turns to a crosshair, then you are clicking and dragging).
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    May 2006
    Posts
    178
    Hi shades,

    I did that but instead of incrementing the day, it increments the year every 2 cells along.


    i.e

    21/08/06-----22/08/06----21/08/07----22/08/07

    any ideas?

    aboo

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    Can you attach a sample with what you have done?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  5. #5
    Join Date
    Aug 2006
    Posts
    21
    if you want to increase them by the date wont a simple equation solve that

    A1= 22/08/06
    A2=A1+1
    then... Fill>>Right>>

    since dates are represented as numbers to excel you just add 1 and its a new day. try that if you want to be specific use month and day functions for other tabs include a calendar on an another sheet if need be.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •