Hi,
I have 5 columns :
Column A : Start Date
Column B : Finish Date
Column C : Actual Start Date
Column D : Actual Finish Date
Column E : % Completion
I want the formula for % completion based on Today Date in Column E.
Hi,
I have 5 columns :
Column A : Start Date
Column B : Finish Date
Column C : Actual Start Date
Column D : Actual Finish Date
Column E : % Completion
I want the formula for % completion based on Today Date in Column E.
Hi,
So do you want to calculate % completion on no. of days from start date?? Please clarify
Click on "* Add Reputation" as a way to say thanks
welcome to the forum, shivamuniyappa. it would be nice if you can upload a sample excel file next time & also manually key in the results for a clearer picture. To upload, Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
and to illustrate your example better, click on How To Get Quick & Good Answers
how do you determine % completion? for eg
Actual Start is 4 Jun 2014. Actual Finish is 6 Jun 2014. today is 5 Jun 2014. what is the the %? is it 66.6%? 2 out of 3 days completed? if so, maybe;
=IF(TODAY()<C2,0,(TODAY()-C2+1)/(D2-C2+1))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
What is the actual percentage completed based on current date against actual start date.
Thanks... I got it ....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks