what is the formula in excel to calcualte percentage of completion for a task
what is the formula in excel to calcualte percentage of completion for a task
=A1/B1
Cell Format as %
Life's a spreadsheet, Excel!
Say thanks, Click *
thank you for your reply: can you help me more please: I have created an Task tracker sheet and it goes like this:
A1 task description
B1 start date
C1 end date
D1 duration
E1 % completion
how can I calculate the % of completion up to date for a task
thanks
Is D1 today's date less the start date? If so d1/(c1-b1) should do it.
thanks for your help, but it is showing me Error.
O.k. if this is not too much to ask, can anyone send me an excel sheet with the formula to see how it is done, I would be greatful
thanks
Better that you post your spreadsheet so we can see what you've done
you're right, thanks. please find attached.
regards,
Tasks%20Tracker(2).xlsx
Try this. It uses the start and finish date to determine the duration in days and the % complete is the number of days elapsed since the start date as a percentage of the total duration.
thanks again. the percentage is shwoing more than 100%. I need the following like for example
if:
A2: prepare communication plan
B2: start date: 01/08/2014
C2: finish date: 10/08/2014
D2: Duration: 9
E2: percentage of completion till date: let's say today is the 4/08/2014
what is the formula for calculating the percetange of completion for this task till date 04/08/2014?
I really appreciete your help. thanks again
Tasks%20Tracker(2).xlsx
Try this. I'm assuming the % completion is the amount of time elapsed from teh start date divided by the entire duration.
If the start date is after todays date the activity hasn't comemnced yet so the % complete is blank. If todays date is after the end date the activity is finsihed and it returns 100%. For todays date bewteen the two the completion % formula is time elapsed /duration
thanks again very much
would it be possible to make the activity that has not strated yet to show 0% instead of showing blank.
best
Real_madrid
Absolutely. In the if formula change the "" to a zero. The two inverted commas together simply tell excel to show a blank. If you get stuck I'll do it but have a go. Easiest to change the top formula and copy down by dragging or even double clicking bottom right corner of highlighted cell.
thanks. I did it.
best
Well done. You should mark this as solved now.
thanks again for helping me out last time.
one think I noticed that I need too, is how can I show the actual % of completion
for example: please find the attached.
regards,
Looks like you've got the completion as a decimal. Just format it as %
Thanks i was searching for it and found it here, just joined forum and downloaded to understand it correctly.
I also need to Calculate and display the Percentage of Completion for a task. But I needed to have as a result several options. Can it be done with Nested IF and how would it be done
This is what I would like to get:
If today is <1% then would like to show: NOT STARTED
If today is <100% but >0% then would like to show: (the actual Percentage)
If today is =100% then would like to show: COMPLETED
If today is >100% then would like to show: DELAYED
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks