“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I need a formula to calculate a graduated penalty rate:
Month 1-3: 1% per month
Month 4-6 2% per month
Month 7-9 3% Per Month
Moth 10-12 4% per month
After 12 months total penalty charged 30%
After that 1.25% per month

Solved by K. L. in 16 mins

I need help with calculating capacity in workdays

Solved by M. H. in 24 mins

i would like to know if there is any way in excel to count days between dates and the answer should be devided by month for an example between jan 12 2018 to feb 8 2018 there is 13 workdays in jan and 6 workdays in feb

Solved by Z. L. in 16 mins

Sheet 1: Calculate the average based on workdays -Monday, Tuesday, Wednesday, Thursday, Friday. Refer to Column N for where the solutions need to be. We need to find the average amount of times something is being prepped according to the day of week.

Solved by G. C. in 17 mins

Hi I'm stuck with a pivot chart trying to calculate the average of mistakes per area. I have the chart to that point. per week and area and shows bar for total amount and total mistakes per area and an average of those mistakes base on totals per area. I will like to show an overall average. For example if I filter for a week for all areas that I can see the average per area and the overall average. please help.

Solved by O. D. in 19 mins