Date Schedule Wrangling/Manipulation

[gwiz]

I have a tricky part of a project I am working on where there is a schedule of dates. I want to sum the amount(s) based on the date ranges. I have provided an example. Essentially, in one row the Start column can be 5/1/2018 and the End column can be 11/30/2019 with an amount of $100. But then another row will be Start of 7/30/2017 and End of 6/30/2019 with an amount of $35. So I need to sum the amounts for the time period that those amounts are for.

Would like it to look like this or at least need the amounts as a result of this

           Start           End           Amount

      7/30/2017 | 4/30/2018   |    $35

      5/1/2018   | 6/30/2019   |    $135

      7/1/2019   | 11/30/2019 |    $100

I have tried to manipulate the data but to no avail! I would love some help solving this! Thanks

**Note: I do not need to group by ID/it does not impact what I am trying to do above

[Tyro_abc]

My understanding is, every interval will include the amount from its sub-interval. If that's the case, this solution should work, though for a very large number of records it might have some performance issue.

 Let me know if it works!