Forum Discussion
Running percentage
I want to create a formula that calculates the percentage of days that I completed a task throughout the month. For instance, I want my formula to calculate 90% if I complete a task 9 days out of the first 10 days of the month, and I want this formula to automatically calculate or update based on how many tasks I completed for each subsequent day of the month all the way to the end of the month.
Thanks to whomever helps me with this.
2 Replies
Thank-you sir for your help to-date.
Unfortunately, I don't know how to provide a link to a cloud storage.
The way the data is laid out is that in column A I have the dates of the month from the 1st to the 31st.
Then in column D is the where I indicate if the task was completed for that day using a "Y" if completed, and leaving it blank if it was not completed for that day.
Then in cell D45 is where the % calculation occurs. I want this calculation to update for each passing day of the month, based on how many "Y" have been recorded to-date.
I hope this is enough detail.
It is really hard to help with limited information. A sample workbook is really helpful and if you can't attach it then providing a link to a cloud storage like onedrive or google drive works too.
That said, I have no idea on how you have the data laid out. For example is this a running list of tasks and dates completed? or is this just a list of task completed this month?
Let's pretend you have column A as task and column B as date completed. And then you want to count all tasks with completed dates this month and divide by #days this month:
=COUNTIFS(B1:.B999, ">"& EOMONTH(TODAY(),-1) ) / (TODAY() - EOMONTH(TODAY(),-1) )
But your specific case may be very different depending on what data you have and how your data is arranged. At least I hope this might get you started.
