New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

How do I increase dates incrementally in excel?


Post Reply New Thread Subscribe

 
Thread Tools
lara

 
Member Since: Nov 13, 2010
Posts: 1
lara is on a distinguished road

lara is offline
Hi,

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

I'm currently using this formula:

=DATE(YEAR((B13)),MONTH((B13)),DAY((B13)+14))

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
QUOTE Thanks
clive12

 
Member Since: Sep 22, 2010
Location: London
Posts: 197
clive12 is on a distinguished road
Mac Specs: Imac 21.5 Inch 3.06 GHZ 4GB Ram 500 Gig HD, Ipad 32 GB, Iphone 4S 16 GB.

clive12 is offline
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

1/10/10

and in cell 2

2/10/10

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.
QUOTE Thanks

Post Reply New Thread Subscribe


« Saving MS word files | E-Mail Woes..... »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Can't open big Excel workbook on MacBook Air SergeiV OS X - Apps and Games 1 06-01-2010 04:01 AM
MAC excel 08 vs PC excel 07 gcookie OS X - Apps and Games 2 05-30-2010 11:32 PM
EXCEL (Office 2008) running slowly, freezing? Annettest OS X - Apps and Games 4 01-21-2010 05:33 AM
Excel - quits automatically and gives error report I don't understand aprildentist OS X - Apps and Games 1 09-28-2009 01:21 PM
Excel or Mac Garoolgan OS X - Operating System 4 04-26-2008 12:07 PM

All times are GMT -4. The time now is 08:03 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?