Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

This question already has an answer here:

I tried to google for a while but it seems to have no straight forward way to do this math.

For example, we have the date at B2 12/31/2012 and need to add 2 months to it and store value in B4. What is the direct formula to use? I rather not using any 3rd party addon(s).

share|improve this question

marked as duplicate by Ƭᴇcʜιᴇ007, Tog, Dave M, Excellll, Olli Jan 31 at 9:30

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1  
It's unclear what you're trying to do. Can you provide an example? –  gronostaj Jul 29 '13 at 19:57
1  
Using EDATE function as @Toni Toni Chopper answer below is what I'm looking for. Thank you! –  Nam G VU Jul 30 '13 at 6:20
1  
Still, please improve you questions so other people with similar problem can find it and use that solution. –  gronostaj Jul 30 '13 at 9:35
    
I agree ^^. Thank you –  Nam G VU Jul 30 '13 at 10:37
add comment

1 Answer 1

up vote 3 down vote accepted

http://office.microsoft.com/en-ie/excel-help/add-or-subtract-dates-HP010342155.aspx#BM5

You can use the EDATE function to quickly add or subtract a specific number of whole months to or from a date.

The EDATE function requires two values (also referred to as arguments): the start date and the number of months that you want to add or subtract. To subtract months, enter a negative number as the second argument (for example, =EDATE("2/15/10",-5). This formula results in the date 9/15/09.

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.