EXCEL

[TammyP]

I have two columns in excel.
One is a duration with a year, the other a commencement with year, month and
day.
How do i calculate these two columns to give a future date.

[Karthik]

Enable the analysis toolkit addin.
In col A give the duration in Month in col B enter the date.
In C1 enter =EDATE(B1,A1)

Format the Col C to date format

Karthik