Completion Percentage of a date range

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)/C2>1,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

This work well. Thank you very much

"Springbok" wrote:

> 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)/C2>1,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

Hello Jon,

I was stuck in this problem for an hour and then I found your solution. Thank you a ton for saving me. It works perfectly on Excel 2019

Take care

Adib