Get instant live expert help on average days per month
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
NEED PRO RATA COMPUTATION FOR LEAVE AVAILABLE DAYS,PER MONTH IS 2.5 DAYS,EXCEL SHOULD BE UPDATED PER DAY
Solved by G. E. in 28 mins
I have built a dashboard and would like to populate date into a few columns to show average daily sales (month), average of past 3 days, average of past 7 days . This data pulls from a master file.
Solved by K. J. in 27 mins
By product I want to be able to look back on total quantity on back order.
For example, t100 ac zolls have been on back order for approximately 10 days, per month. This would date back to the oldest day per month, showing that the item was on back order for x amount of days.
Solved by M. L. in 20 mins
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
Trying to calculate the average monthly sales, average sales for past 3 days, and average sales for past 7 days into 3 columns.
I was working with someone, but what they created was not correct.
for 3 days
=SUMIFS('PPC Spend Raw'!$P:$P,'PPC Spend Raw'!$A:$A,"<="&TODAY(),'PPC Spend Raw'!$A:$A,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-3))/3
For the past 7 days:=SUMIFS('PPC Spend Raw'!$P:$P,'PPC Spend Raw'!$A:$A,"<="&TODAY(),'PPC Spend Raw'!$A:$A,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-7))/7
Solved by B. U. in 19 mins