formula needed to calculate a date

  • Thread starter Thread starter Louis
  • Start date Start date
L

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
 
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)
 
Back
Top