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

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