Get instant live expert help on average weeks in a month

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

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.

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

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?

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?