You are absolutely right! Thanks for pointing that out!

Regards!
Jean-Guy

"David Biddulph" wrote:

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.
--
David Biddulph

"pinmaster" wrote in message
...
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.

"pinmaster" wrote:

Hi,

=A1+DATE(0,B1,0)

"Dal1981" wrote:

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