Calculate Months from number in range

[Prashantvk123]

Hi All,

Hope you are doing well,

I have following data set,
Date Months
07/11/2014 1
06/11/2014 6
05/11/2014 3

from this data i want to calculate closing date. for e.g. if start date is 07/11/2014 and Months is 1 than in next column it should show closing date as 08/11/2014, as it is going to be closed after one month.

could you please help me in the case....hope I have explained it well..

 

[Debraj]

Hi Prashant..

try this..

in c2 use formula as..
=DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1))

 

[Prashantvk123]

Really Awesome.....great....

Thanks a lot Deb...