Use the DATE() function. With the date in A1 and number of months in B1 try
the below formula in C1. Copy down as required...

In C1
=DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1))

If this post helps click Yes
---------------
Jacob Skaria


"wins007" wrote:

Hi everyone,

I currently have a problem with the calculation of some dates based on an
existing one. I need to calculate a new date based on an original date Col A
to which I need to add a figure which relates to number of months to be added
Col B to produce a new date Col C.

A B C
03/15/2009 2 05/13/2009
04/06/2009 3 04/07/2009
02/28/2009 1 03/28/2009

Your valuable help will be welcomed.

Thanks for your usual support