Distribute the Number 1 between two Dates|General Excel Questions & Answers|Excel Forum|My Online Training Hub

I am looking for the formula that does the following spread / distribution between a start date and an end date: if the start date is mid month it calculates 14/31, etc, then between the start and end months inserts the value 1 and for the final month identifies the value of the end date 10/31. e.g. refer to the table below.The values not equal to 1 are to be rounded up. The months reflected in the columns are the end of the month e.g. 31 Oct or 30 Nov, etc

1. Net Programme

   Oct-19

   Nov-19

   Dec-19

   Jan-20

   Feb-20

   Mar-20

   Apr-20

   May-20

   Jun-20

   Jul-20

   Aug-20

   Sep-20

   Oct-20

   Nov-20

   Dec-20

   Start Date

   End Date

   2019

   2020

   Q 4

   Q 1

   Q 2

   Q 3

   Q 4

   Overall Project

   Contract Award -> Practical Completion

   14/10/2019

   10/12/2020

   0.5

   1.0

   1.0

   1.0

   1.0

   1.0

   1.0

   1.0

   1.0

   1.0

   1.0

   1.0

   1.0

   1.0

   0.4