Projected End Date

[jealkon]

Excel 2003

First column is date formatted mm-yyyy (01/2011)
Second column is number format (used for number of months)
Third column is what I need to project as the end date
So if I add 48 months to Jan 2011, I'd get Jan - 2015

Thanks for your help

[Cutter]

Try this:

=EDATE(A1,B1)

A1 holds the date value and B1 holds the number of months

Requires Analysis Tool Pack for Excel 2003 - see link for details of function and ATP installation

http://www.excelfunctions.net/Excel-Edate.html

[jealkon]

Thanks so much - tried that originally and didn't get result I needed, turns out that I didn't have the second column formatted correctly

[DonkeyOte]

If you want to avoid Analysis ToolPak dependency (pre XL2007) you can:

Please Login or Register  to view this content.

(above assumes per profile 1st of month at all times)