Results 1 to 2 of 2
  1. #1

    Member Since
    Nov 13, 2010
    How do I increase dates incrementally in excel?

    I need to increase dates in excel incrementally by 14 days each time.

    I'm currently using this formula:


    It's kind of working in that it increases the date by 14 days (06/11/09 to 20/11/09 to 04/11/09). How do I get it to change the month as well without making it into a really long IF formula?

    Thanks for your help

  2. #2

    Member Since
    Sep 22, 2010
    Imac 21.5 Inch 3.06 GHZ 4GB Ram 500 Gig HD, Ipad 32 GB, Iphone 4S 16 GB.
    Its very easy to do without using a formula.

    Put your first date in cell 1
    Put your second date in cell 2

    Make your second cell the date you want to increase by, so if you want to make each new cell the next day then in cell 1 you would have


    and in cell 2


    highlight both cells and then hover over the bottom right of the last cell and your cursor will change to a black + symbol

    Drag down the cells through the blank cells you want to auto fill.

    Excel will add a new date in each cell you drag through.

    It also works for things like days and other strings where there is a logical next value.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel for Mac and Excel for Windows
    By newbimac in forum macOS - Apps and Games
    Replies: 5
    Last Post: 09-23-2015, 01:34 PM
  2. some dates
    By Yodda_Hunter in forum macOS - Operating System
    Replies: 5
    Last Post: 06-14-2013, 02:23 PM
  3. some dates
    By Yodda_Hunter in forum Other Hardware and Peripherals
    Replies: 0
    Last Post: 06-13-2013, 08:50 AM
  4. Replies: 0
    Last Post: 01-30-2013, 10:00 AM
  5. Incrementally Opening ZIP Files
    By Zeigh in forum macOS - Operating System
    Replies: 0
    Last Post: 12-20-2010, 10:27 PM

Posting Permissions

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