Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
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.... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula
Start date in A1
End date in A2 In A3 enter =(TODAY()-A1)/(A2-A1) Format to percentage. Gord Dibben MS Excel MVP On Tue, 11 Sep 2007 09:02:04 -0700, 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.... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|