Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 '14 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.

It's unclear what you're trying to do. Can you provide an example? – gronostaj Jul 29 '13 at 19:57
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
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
up vote 4 down vote accepted

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

Not the answer you're looking for? Browse other questions tagged .