Hi Brian,

I think this is right?

Assume Column A is Task, B is Start Date, C is No. of Days, D is End Date
and E is % Complete.

D2=B2+C2
E2==IF((TODAY()-B2)/C21,1,IF((TODAY()-B2)/C2<0,0,(TODAY()-B2)/C2))

E2 should be formatted as %.

Give it a crack and let me know.

Cheers,
Jon

"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