Formula
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
"AMQ" wrote:
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....
|