Formula
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)
--
David Biddulph
"Mike H" wrote in message
...
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....
|