Daily revenue recognition with start date and end date by quarters

Hi Everyone - This is a shot in the dark. I am hoping someone would know this. I am trying to calculate revenue for bookings which have start and end dates across the month and I want to show by quarter revenue on daily recognition. I have attached a spreadsheet. I tried to do and I was partially successful.

Thank you for looking. Greatly appreciated.

shakeexcel