Forum Discussion

Russ_Tech12's avatar
Russ_Tech12
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 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.

Formulas and Functions

1 Reply

  • m_tarler's avatar
    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.

Resources