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