Dynamically populate a row of cells based on value and date range

Hi All (First post so please be gentle ).

I have created a resourcing spreadsheet/tracker for the period April 2016 to March 2017. The first 10 or so columns contain specific data relating to the people (resource). The next set of columns are split into months/weeks/days with each cell across a given row representing 1 workday. I would like to make it easier for people to complete the spreadsheet by attempting to do the following:

Just before the start of the columns containing the dates and on each row containing specific resource data, 1) Allow the user to enter (a) a start date and (b) an end date and (c) the average resource usage per week i.e. say 2.5days. I would like the formulae (probably more likely to be VBA), to be able to do the following d) average out the entry in (c) across each week and split it equally between the date ranges provided in a and b - automatically populating the cells between the two date ranges as denoted by the column headers so taking the example, we would have "0.5" for each workday automatically populated/enetered in the cells between the two date ranges specified in (a) and (b).

I hope this makes sense and thank you to anyone who can help me as everything I have tried so far does not seem to hit the mark.

Many thanks all.

P

Please, can you upload a sample file with a example of what you have and what you expect?