Forum Discussion

Occasional Reader

Oct 13, 2025

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...

Formulas and Functions

m_tarler

Bronze Contributor

Oct 13, 2025

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.