+ Reply to Thread
Results 1 to 3 of 3

Thread: 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 09:46 AM. Reason: Problem solved!

  2. #2
    Valued Forum Contributor Haseeb A's Avatar
    Join Date
    05-24-2011
    Location
    India | Kwt
    MS-Off Ver
    2007
    Posts
    1,447

    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)
    HTH; Haseeb

    If your problem is solved, please say so clearly, and mark your thread as Solved:
    Forum Rules & How to Mark a thread as SOLVED

  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.2.0