+ Reply to Thread
Results 1 to 3 of 3

Excel 2008 : Duplicating, then incrementating dates

  1. #1
    Registered User
    Join Date
    01-04-2012
    Location
    USA
    MS-Off Ver
    Excel 2008 (MAC)
    Posts
    2

    Thumbs up Duplicating, then incrementating dates

    I'm trying to duplicate a series of dates while incrementing by 1 every 2 rows.

    For example:
    January 10, 2012
    January 10, 2012
    January 11, 2012
    January 11, 2012
    January 12, 2012
    January 12, 2012

    I've searched high and low for an answer, but can't seem to find what I'm looking for. I know it can be done with numbers, but I can't seem to find a formula/method for dates. Hope someone can lead me in the right direction.

    Thanks
    Last edited by denise032; 01-05-2012 at 10:46 AM. Reason: Problem solved!

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Duplicating, then incrementating dates

    One way,

    Let's say the start date is in A2. So use this formula in A3, then copy down.

    =A$2+INT(ROWS(A$3:A3)/2)
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Registered User
    Join Date
    01-04-2012
    Location
    USA
    MS-Off Ver
    Excel 2008 (MAC)
    Posts
    2

    Re: Duplicating, then incrementating dates

    Thanks! You're a lifesaver!!

+ 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