Creating a formula to populate range of cells between dates based on start and end dates

Hello All,

I hope you can help.

I am trying to create a formula, which populates a range of cell (months) based on a given start and end date AND based on resource utilisation. Below is an example of what I am attempting to achieve as an end result:

Attachment 332596

I wish the populated cells to be formula driven by the (headcount x days available in the month) and only for the months between the date range (start and end date).

I look forward to your help and guidance.

Many thanks in advance,
Remon