Hi Tony!



Unfortunately, we don't have MS Project, I have to make do with Excel.

Here's the example, it's random but accurately reflects the task I need to solve. I would like to calculate the finishing date of the completion of all tasks (the one starts after another), and also the date each of the task is completed (only day, not interested in time of the day).

Thanks in advance!

Attached Files

Scaffold's Example.xls (15.5 KB, 19 views)

Hi Scaffold
Your solution is attached.
Basically Excel stores dates as the number of days since 1st January 1900. On that basis, as you have stored your individual task duration's as percentages of a day you just need to add the start date to the number of days for your first task to get the completion date of Task 1. Then for task 2 add the start date to the duration's of Task 1 and Task 2 and so on.
To obtain the end date of all the tasks simply add the start date to all the duration's of each task.
Hope this helps.
Tony(OTPM)

Attached Files

DateFinishCalculation.xls (14.5 KB, 29 views)