title: Interpolation of months between two dates and calculating a sum using a fixed value for each month
body: <p>In a spreadsheet I have a resource estimation for each project with the start and end dates. Every row holds a separate project. Similar to what's below:</p>
  
  <p><a href="https://i.stack.imgur.com/qsY2j.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qsY2j.png" alt="enter image description here"></a></p>
  
  <p>I would like to interpolate the months between Start and end Go Live date and use the same effort for each month. Ultimately, I would like to use this in a pivot table to sum up the monthly totals. It would like similar to below (calculations done quickly by hand so please excuse errors):</p>
  
  <p><a href="https://i.stack.imgur.com/rDTgg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rDTgg.png" alt="enter image description here"></a></p>
  
  <p>I'd prefer to use any out of the box functionality but if necessary I can also code this. Any pointers would be appreciated. </p>