Thanks John, this seems to have done the trick!!

Thanks also to Jean-Guy and David!

Kind regards,

Dal

"john the confused" wrote:

try putting =EDATE(A1,B1) in cell c1

"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