How do I add Months to a 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
 
G

Guest

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
 
D

David Biddulph

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))
 
D

David Biddulph

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.
 
G

Guest

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

Need to add 18 months to a date 3
Date formatiing - using code to show months 2
Convert a string to a date? 3
date formulas 9
Formula alteration help! 5
Calculate # of months if a date is given 4
How to subtract/add periods in monthly base? 3
Formula to show 2 months within 3rd birthday 4

Top