Get instant live expert help on average workdays per month

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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