Calculating a date 30 months ahead from a given date

[dstokes]

Hi,
I have a series of dates in a workbook and I need to place in an adjacent cell each of these dates plus 30 months. I am using Excel 2002. Is there a formula that I can use to quickly solve this problem. Any help given will be gratefully received.
Thanks,
Diarmuid

[VBA Noob]

Try

=DATE(YEAR(A1),MONTH(A1)+30,DAY(A1))


VBA Noob

[daddylonglegs]

If you can use EDATE (which requires Analysis ToolPak add-in) then that's the simplest way

=EDATE(A1,30)

which doesn't always give the same results as

=DATE(YEAR(A1),MONTH(A1)+30,DAY(A1))

e.g. if A1 is 31st August 2006 then the first formula returns 28th Feb 2009, the second 3rd March 2009