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