You have already decided on your columns. Keep to that. To determine the
end date, use the formula B2+D2. To calculate %completed, use this:
=((NOW()-B2)*100)/D2, otherwise you will always get 15%


"Brian" wrote:

I have started a task sheet in excel and i have a "task description" coloumn,
a "start date", "finish date", "number of days" and a "% complete" column.

What i want to achieve is the user to enter the first task start date and
the number of days it will take to complete. Then excel will work out the end
date and the percent complete field relating to the current date.

Is there a easy formula of working out the percentage?

Many thanks