Calculated % completed by date

[kp56]

Hello,

I need to calculate the earned value on a project, and for that I nee
to enter the percent complete based on date.

So if a project begins 3/1/2012 and ends 9/1/2012, based on today's dat
what percent complete is it?

Thank you

 

[Spencer101]

Hello

I need to calculate the earned value on a project, and for that I nee
to enter the percent complete based on date

So if a project begins 3/1/2012 and ends 9/1/2012, based on today's dat
what percent complete is it

Thank you

Assuming your start date is in A2 and end date in B2, tr
*=(TODAY()-A2)/(B2-A2)* in C2 and format as percentage

If the end date has passed you will get odd results, but you could avoi
that with something like...
=IF(C2<TODAY(),\"PROJECT COMPLETED\",(TODAY()-A2)/(B2-A2)
Let me know if that's what you need, or indeed if it's not what yo
meant at all

S

 

[joeu2004]

So if a project begins 3/1/2012 and ends 9/1/2012, based
on today's date what percent complete is it?

If the start date is in A1 and then end date is in A2, perhaps the following
will meet your needs:

=(TODAY() - A1) / (A2 - A1)

formatted as Percentage.