Excel Tips and Tricks / Business Reporting 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.
4. The project will end on the 18-10-2012, as given below: