Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Oct 2009
    Posts
    471
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Excel 2010 - Make a list of dates that run every-other day

    Hi,

    I am using Office 2010. In Excel, I would like to make a list of dates that run every-other day, e.g., March 10, March 12, March 14, etc. Can this be done without having to type each date?

    Thank you.

    Moon1130

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    This works in Excel 2003.....
    Type March 10 in a cell
    Type March 12 on the next row
    Highlight those 2 cells and drag down the fill handle that appears in lower right.

    Note: The fill handle looks like a plus sign.

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Or type a date in say A1, then in A2 enter =A1+2 and copy A2 down as far as required. That way, if you need to change the start date, you only need to change A1.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    4 Star Lounger
    Join Date
    Oct 2009
    Posts
    471
    Thanks
    3
    Thanked 2 Times in 2 Posts
    Thank you very much tfspry and rory. I tried both of your suggestions and they worked out perfectly.

    Have a very Good one....

    Moon1130

Posting Permissions

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