Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AMQ - 11 Sep 2007 17:02 GMT

I am creating a worksheet to measure completion of a project/order. What
formula/function can I use to figure out the percentage of completion? I
have formulas for start/end days, but don't know where to go from there....

Reply to this Message

Gord Dibben - 11 Sep 2007 17:21 GMT

Start date in A1

End date in A2

In A3 enter =(TODAY()-A1)/(A2-A1)

Format to percentage.

Gord Dibben MS Excel MVP

>I am creating a worksheet to measure completion of a project/order. What
>formula/function can I use to figure out the percentage of completion? I
>have formulas for start/end days, but don't know where to go from there....

Reply to this Message

Mike H - 11 Sep 2007 17:32 GMT

Knowing the start and end date doesn't really lead to % project completion
because it could be running late or early but it can allow a calculation of
the % of used time. For example with the start/end dates in a1 and b1 the
formula below calculates the % of used time.

=DATEDIF(A1,NOW(),"d")/DATEDIF(A1,B1,"d")

To calculate % completion you need another measure but a more common method
would be to enter the project into a gantt chart.

Mike

> I am creating a worksheet to measure completion of a project/order. What
> formula/function can I use to figure out the percentage of completion? I
> have formulas for start/end days, but don't know where to go from there....

Reply to this Message

David Biddulph - 11 Sep 2007 18:43 GMT

But you probably don't need DATEDIF in this case.

=DATEDIF(A1,B1,"d") is the same as =B1-A1 (except that the latter will deal
with fractions of a day, if date and time are included).
More strictly, =DATEDIF(A1,B1,"d") presumably gives the same result as
=INT(B1)-INT(A1)

Signature

David Biddulph

> Knowing the start and end date doesn't really lead to % project completion
> because it could be running late or early but it can allow a calculation
[quoted text clipped - 14 lines]
>> have formulas for start/end days, but don't know where to go from
>> there....

Reply to this Message