11-13-2010, 05:55 AM #1
How do I increase dates incrementally in excel?
- Member Since
- Nov 13, 2010
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
11-13-2010, 06:51 AM #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.
Users Browsing this Thread
There are currently 4 users browsing this thread. (0 members and 4 guests)
By newbimac in forum OS X - Apps and GamesReplies: 5Last Post: 09-23-2015, 02:34 PM
By Yodda_Hunter in forum OS X - Operating SystemReplies: 5Last Post: 06-14-2013, 03:23 PM
By Yodda_Hunter in forum Other Hardware and PeripheralsReplies: 0Last Post: 06-13-2013, 09:50 AM
By 1611mac in forum OS X - Operating SystemReplies: 0Last Post: 01-30-2013, 11:00 AM
By Zeigh in forum OS X - Operating SystemReplies: 0Last Post: 12-20-2010, 11:27 PM