How do I add Months to a date??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

How do I get Excel to add a certain number of months to a date??

For example if cell A1 I have the date 7th February 2007 and in cell B1 I
had 18 (the number of months I wanted to add)
What formula would I have to put in cell C1 so that it adds 18 months to 7th
February 2007, thus giving the answer 7th August 2008?

Any help would be appreciated!

Thank you & kind regards,

Dal
 
Guess I should have paid more attention to the result, short by 1 month so:

=A1+DATE(0,B1+1,0)

but I would go with John's answer.


Regards!
Jean-Guy
 
That formula gives 8th July 2008, so you're about a month adrift.
If you want 7th August 2008, try
=DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1))
 
Closer, but can still be a few days adrift, for example when adding 18
months to 28 Aug 2007, your new formula gives 25 Feb 2008.
 
Thanks John, this seems to have done the trick!!

Thanks also to Jean-Guy and David!

Kind regards,

Dal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Month Display 8
Convert a string to a date? 3
Formula for searching 3 criteria 4
Datedif gives wrong result 1
Date formatiing - using code to show months 2
Cell Referencing between multiple worksheets 3
How to subtract/add periods in monthly base? 3
Year-to-date based on current month 2

Back
Top