Incorrect Pivot Table Aggregation from Day to Week

Hi team, I’m using a pivot table to aggregate the sum of hours by month, and was seeing discrepancies in what was expected. When I changed the date aggregation to “Day” the data was correct, but isn’t getting rolled up into Month correctly.
As seen below, 12/11, 12/7 and 12/6 should all be included in Week of 12/11 (28 + 8 + 4) but the weekly aggregation for 12/11 only shows 28.
Same for 12/4, 12/2, and 12/1 (14 + 24 + 2) but Week of 12/4 only shows 26 hours.

Any ideas on how to fix this? Thanks!

Weeks in quicksight start on Sundays. Do you want them to start on Mondays?

You can look to this post for that.