Formula for achieved/not achieved percentage

Hello,

We are a company which rely on paperwork sent from multiple locations. We want to track which locations are sending in their completed paperwork daily and have a result at the end of the month. For example:

1) 30 days and a store made the deadline 15 days, that stores score for the month would be 50.00%

2) 31 days and a store made the deadline 8 days, that stores score for the month would be 25.81%

3) 30 days and a store made the deadline 25 days, that stores score for the month would be 83.33%

I have attached a simplified version of what I currently used. However, my original spreadsheet contains various other columns which are for the rest of the info we are to extract from the paperwork sent in. I will greatly appreciate any ideas that can help me accomplish this.

Thanks!

Newdoverman, once again you nailed it. Im trying to recreate that same pivot table in my spreadsheet but I'm coming across some stumps: How did you get the date field to come up as a month instead of dates? I tried and I keep getting a list of each day per location. The other question is how did you get it to average per month days? This is exactly what I needed!

I figured out how to set up the dates by month. I grouped the data. All I have to figure out know is the percentages. Wish me luck!

Thats how I have it set up but its giving me the percentage based on the count of the days instead of the month. I might keep it that way though.

Thank you!!! The pivot table was the easy and organized way to go. I all worked the way I wanted it!!! Problem resolved!