+ Reply to Thread
Results 1 to 2 of 2

Incrementing date change

  1. #1
    Registered User
    Join Date
    05-12-2010
    Location
    san francisco, CA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Incrementing date change

    I am not really sure how to search for this, so I apologize if this is mentioned somewhere.

    I know if you type todays date, then drag the little box down the date will incrementally change to the next day, then the following, etc...

    Is there a way to have the increments by 66 cells (or any # cells, therefore)? So I have 66 cells that say 5/1/2010, and I would like to have the next 66 say 5/2/2010, etc. and if there is an easier way then dragging down the last 5/1/2010 to make 5/2/2010 (e.g. cell 66 to 67) and then copy/paste to the next 65 cells, I would really appreciate to find out.

    Thank you for any possible feedback.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,483

    Re: Incrementing date change

    If A1 to A66 is one date, then A67 = A1+66
    Drag that down for the next 66 days

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1