#### mfaisal.ce

##### Member

Dear,

I have 2 columns

column b has months from jan to dec and column C has production values on monthly basis.

i need to calculate weekly production based on date given in A1.

Week starts from Sunday and ends in Saturday.

For example

consider A1 is 1st july 2024. it means the week is 30-06-24 sunday to 06-07-24 saturday. formula should sum the values of 1 day of june production and 6 days of july production to give output as weekly production.

regads,

I have 2 columns

column b has months from jan to dec and column C has production values on monthly basis.

i need to calculate weekly production based on date given in A1.

Week starts from Sunday and ends in Saturday.

For example

consider A1 is 1st july 2024. it means the week is 30-06-24 sunday to 06-07-24 saturday. formula should sum the values of 1 day of june production and 6 days of july production to give output as weekly production.

regads,