Weighted Numbers Greater Than Whole

I have a set number that I need to allocate over a flexible period of say 5 -11 days.

I have applied the traditional split per day to each number i.e. a monday normally results in 20% of transactions, Tuesday 25% etc.

The issue comes in when I try to allocate the budget over a period longer or shorter than a week.

Therefore the budget for the 9 days is being allocated over the period of 9 days which results in a overall allocation of 150%. (duplicate mondays etc).

Is there a way to limit the entire period to a set number and have the numbers adjust themselves accordingly up or down to match it other than multiplying it by a factor?

Example attached: Excel Problem.xlsx