Get instant live expert help on average days in a 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 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
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
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
(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
Add a total row to display the average percentage of list price and average number of days on market. Format the average number of days on market as a whole number. Use an appropriate label for the total row.
Solved by M. S. in 17 mins