Get instant live expert help on average weeks 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 need help with this formula: =ROUND(SUMPRODUCT((MONTH(A2:A10413)=12)*(I2:J10413))/INT(SUMPRODUCT((MONTH(A2:A10413)=12)/7)),0) it si not giving me an acurate output. i have A1 with multiple dates I & J have amounts i need the formular to find all dates in the first month then calculate the number of weeks in that month then divide it into the total for that month from B & C colums to give an average for that month and so on for each month. Eg: Jan Date 1/01/2018 to 30/01/2018 = 4 weeks divided into B& C totals for Jan Feb Date 10/02/2018 to 30/02/2018 = 3 weeks divided into B & C totals for Jan
Solved by C. C. in 28 mins
Hello, can you me with average meaning? My homework is to find the average time between Column B and Column E in the Subscriptions sheet broken down into days, weeks, and months. Average time in 2014 and 2015.
Solved by V. H. in 25 mins
is there anyway to show one cell result in one sheet to another, the example is a cash flow sheet with 5 sheets for the 5 weeks, and a sheet for the month end, detailing all the 5 weeks. on the weekly sheets there is a week end total, and to repeat that in the month end sheet
Solved by Z. F. in 11 mins
I have a stock volume in column A. I then have a forecasted sales volume by week for 10 weeks in the nest 10 columns. I need to include a formula which tells me how long the stock in column A will last in weeks. This needs to be dynamic and adjust if I adjust up or down the sales forecasts in a given week. I cant use an average as certain weeks will have heavy spikes or dips. Can you help me with the average value of a function calculator?
Solved by C. A. in 30 mins
I've got a questionnaire that is being answered by individuals and the data is input into a sheet that gives a timestamp when it is entered. I want the data track up to the current day the past week & also have tracking of the past month or six weeks. The data may be input giving 3-5 inputs per week however based on all the dates input I want an overall average. For example that may mean 3 or 4 inputs from the last week which would be average by the number of inputs. Also over the past month or six weeks the same thing which may be between 20-30 inputs. Any idea of what to do?
Solved by K. A. in 30 mins