Get instant live expert help on average working days in a 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
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
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
I am working on a formula to calculate pay. However I want to ensure it accurately takes into consideration start date and number of days before the end of the period (month). I currently have a formula in there and it is doing the calc based on weeks (assumption they start at the beginning of the month), however, if someone starts in the middle of the month, I need it to calc the number of days through the end of the month. I have the cells i'm working on highlighted in red.
Solved by K. J. in 25 mins
(Current year Receivables + Last year Receivables)/2 Sales/normal receivables *365 days 365 days/Receivable turnover rate 2016 $ 43,757,500,000.00 8.25 Times 44.24 Days $ 6,650,000,000.00 71.97 Times 5.07 Days Average record payable/Cost of offer *365 days 38.81 Days Production cycle + Average accumulation cycle - Average installment cycle 10.51 cycle condition indicates 11.28 days.
Solved by K. S. in 16 mins
how can i built in all the days of a month in a month using a dynamic calendar
Solved by K. H. in 23 mins