• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Monthly sales by week (7 days) not week number

geo Jul

New Member
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​
 

Attachments

  • Chandoo 1.xlsx
    15.1 KB · Views: 3
I'm not sure of the problem, but look at using the EOMONTH function to identify the parameters of the sum.
 
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))))
 

Attachments

  • geo Jul Chandoo 1 365 AliGW.xlsx
    15.2 KB · Views: 4
Back
Top