Business Automation and Software Blog

Excel Tips and Tricks: Future Dates Projection

Posted by Robert Baran on Fri, Jan 11, 2013 @ 12:10 PM

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:


Contact PositiveVision ► ► for a Complimentary  Reporting Consultation

Topics: Business Reporting, Excel Tips and Tricks