Monthly sales by week (7 days) not week number

[geo Jul]

Dear All Experts and Geniuses​

I need a formula to sum monthly sales by week (7 days) and the remaining days of the month not to be carried to the next month​

not by week number by seven days starting from 01/01/2024​

and I wish not to carry the partial days to the next month​

Regards​

 

[AliGW]

Which version of Excel are you using?

 

[AliGW]

I'm not sure of the problem, but look at using the EOMONTH function to identify the parameters of the sum.

 

[AliGW]

In O5 copied down:

=LET(m,MOD(DAY(N5),7),SUM(FILTER($D$6:$D$106,($B$6:$B$106>N5-IF(m=0,7,m))*($B$6:$B$106<=N5))))

 

[geo Jul]

In O5 copied down:

=LET(m,MOD(DAY(N5),7),SUM(FILTER($D$6:$D$106,($B$6:$B$106>N5-IF(m=0,7,m))*($B$6:$B$106<=N5))))

Your assistance on my criteria has been greatly appreciated and has had a significant impact

 

[AliGW]

Great.