Future Dates Projection

Question:     How can I calculate the date that a project ends, this date falls after a certain amount of years, months and days?

Answer:        By using the Date function, =Date(Year,month,Day)

Why:            To predict the completion date of a project

Applies To:   Excel 2003, 2007, and 2010

1. Refer to the data below







2. To predict the project end date, select B8 an, enter as below

3. =Date(2011+B4,5+B5,5+B6)

4. The project will end on the 18-10-2012, as given below