Formula

[Guest]

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....

 

[Gord Dibben]

Start date in A1

End date in A2

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

Format to percentage.


Gord Dibben MS Excel MVP

 

[Guest]

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

 

[David Biddulph]

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)