Get instant live expert help on I need help with weeks in a month

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 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

We have a spreadsheet to calculate storage in weeks, We have a date in Column, a date out column. We then need to calculate on a monthly basis how many weeks an item has been in storage during a month to calculate invoicing. We are needing a formula to work out this calculation line by line..

I need to create a spreadsheet to track workers for jobs. I need the months to be scroll able but need 4 x 4 small cell boxes under each month to allocate for the the weeks. (needing 52 weeks per year)

i have a problem with a pivot table, one of the columns is weeks. I need to show calculations in the weeks as a sum of the previous weeks.