Adding months to start date to get end date

[Eva_]

I have found several suggestions how to solve a similar problem, but none of them seems to work for me... I know it is no challenge for all you sharp minds, so please help me with the following:

In G6 I have a start date (01-02-2011)
In F6 I have a number of months (24)
In H6 I need a formula to calculate the end date...

Below is one of the suggestions I found in here - but I cannot get it to work... :-(

=MIN(date(year(G6);month(G6)+F6+{0,1};DAY(G6)*{1}))

I use Office 2010...

Look forward to your help... :-)

[daddylonglegs]

You can use EDATE function, i.e. in H6

=EDATE(G6;F6)

[Eva_]

Yes... I just found out myself too and hurried in here to cancel this request - but of course I'm too late... Excel Forum's help is always quick... :-)

Thanks anyway daddylonglegs... :-)

[Marcol]

One way might be

=DATE(YEAR(A2),MONTH(A2)+B2,DAY(A2))

Hope this helps