Future Date calc

[konew1]

Hi. In column A I have a date. In column B I have an integer, I need a formula in C to calculate the date after A that is the number of months stated in B
example
A B C
26-Jun-09 2 26-Aug-09
26-Oct-10 9 26-Jul-11
06-Nov-09 3 06-Feb-10

 

[Rick Rothstein]

What dates would you expect for the following...

31-Dec-10 2
31-Aug-10 3

 

[konew1]

Good question Rick. I want end of month when there are less days in the end month
31-Dec-10 2 28-Feb -2011
31-Aug-10 3 30-Nov-2010

 

[Rick Rothstein]

There is probably a shorter formula than this, but this works...

=MIN(DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1)),DATE(YEAR(A1),MONTH(A1)+B1+1,0))

 

[Rick Rothstein]

Of course there is a shorter formula. This formula (from the ToolPak Add-In if you are using a version of Excel prior to XL2007)...

=EDATE(A1,B1)

 

[konew1]

Thats Rick, the short one is what I wanted.