Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculated % completed by date
Hello,
I need to calculate the earned value on a project, and for that I need 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 date what percent complete is it? Thank you! |
#2
|
|||
|
|||
Quote:
Assuming your start date is in A2 and end date in B2, try =(TODAY()-A2)/(B2-A2) in C2 and format as percentage. If the end date has passed you will get odd results, but you could avoid 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 you meant at all. S. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculated % completed by date
"kp56" wrote:
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Past Due/Completed on time date formula | Excel Discussion (Misc queries) | |||
oldest date not completed | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
How can I match a calculated date to closest date from a list? | Excel Worksheet Functions | |||
Filling a cell with today's date (Datestamp completed marco) | Excel Programming |