Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jan 2002
    Location
    Sonoran Desert, CA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ADD SEQUENTIAL DATE EVERY 10th CELL

    I think this is fairly basic stuff. How do I change the date to the following day every 10th cell in a column? The 10 cell space between dates will contain data relative to the date, and that is why I need the spaces between sequential dates. Thank you.
    Phasr

    Sonoran Desert

  2. #2
    New Lounger
    Join Date
    Dec 2009
    Location
    Illinois
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Let's say you have a date in cell A1. In cell A11 (10 cells down), enter the formula =a1+1.

  3. #3
    Lounger
    Join Date
    Jan 2002
    Location
    Sonoran Desert, CA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you. That works nicely. Now how can I repeat it every tenth cell?
    Phasr

    Sonoran Desert

  4. #4
    2 Star Lounger
    Join Date
    Mar 2010
    Location
    Tampa, FL, USA
    Posts
    114
    Thanks
    11
    Thanked 10 Times in 9 Posts
    With the sheet set up as the previous poster suggested, select cells A2 to A11 (10 rows x 1 column). COPY the selection (ctrl-C), then select rows A12 down as far as you want the sequence repeated, say to row 111. With those 100 rows and 1 column selected, press ENTER to paste the 10 selected cells into the new range as many times as will fit.

    Now every 10th row has a date increased by 1.
    PJ in FL

  5. #5
    Lounger
    Join Date
    Jan 2002
    Location
    Sonoran Desert, CA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts
    That works very nicely. Thanks to all of you! Phasr
    Phasr

    Sonoran Desert

Posting Permissions

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