Not an efficient method, but maybe this can be a starting point.
I made a separate Excel sheet with all the dates in my test set.
Then I tried a join where the dates were between the deal start-end dates.
After calculating the deal portions, it seemed to allow me to sum up the daily amounts
and allow for aggregation by week, month.
partition2.twbx 93.4 KB