formula needed to calculate a date

[Louis]

i need a formula to do the following: i'm supplied w/
the following information:
Beginning Date: 10/01/01

Amount of Time:
3 years
6 months

i need a formula where i can add the 42 months to the
beginning date and that would give me the date 42 months
from the beginning date.

for the example above, the correct answer is 04/01/05

Thanks
Louis

 

[J.E. McGimpsey]

One way:

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

If you (and everyone you send the workbook to) have the Analysis
Toolpak Addin installed, you can use

=EDATE(A1,42)

 

[Arvi Laanemets]

Hi

With your date in A1
=DATE(YEAR(A1),MONTH(A1)+42,DAY(A1))