My problem is the spreading of the line item amounts across the start and end dates (which would have been clear w/o the circrefs - i apologize). Here is a better annotated working version.
Thanks - but it still isn't spreading the costs between the Start Date and End Date. It needs to divide the amount of the line item by the number of months between the start and end date and show that amount in the requisite month. i.e. For a $600k line item, if the Start Date is June 2020 and the End Date is 12/31/2020 then there should be 100k in each month between June and December 2020.
Sorry Again - I forgot to repost the file (notes inside). If its not do-able with a pivot table, then vba or other options would be fine.