Forum Discussion

Copper Contributor

Dec 29, 2025

Need assistance to correct a formula

I am using the following formula to calculate weekly hours. I want to change it to calculate the hours with the starting on Monday going to Sunday and display the result in column G on the Sunday. ...

excel

Lobo360

Brass Contributor

Dec 30, 2025

I’ve also replied on your other post:

Help with changing a formula | Microsoft Community Hub

With an answer that works with your original formula that should work as desired:

=IF(WEEKDAY(A2,2)=7,SUMIFS(C:C,A:A,”>=“&A2-6,A:A,”<=“&A2),””)