How to calculate monthly percentage in Excel

• Calculate the all daily production using Autosum option

• We may get a huge value in overall percentage

• Divide that overall percentage by number of worked days

• We will get a value. Go to format cells and change the format to percentage

• Now the monthly percentage has been displayed