Hi Everyone,
I have a little problem that I would like to seek insights to.
Perhaps anyone has a little more insight in Excel than I do.
I have attached a picture that shows a bit of the problem
Forum Question.GIF

I would like to give start dates and end dates existing in a column of consecutive dates as inputs and then use the rows they are in as row- references to create an average between these dates from values in another column.
Say my dates are in Coumn A starting at row 2 and the values for the respective rows are in B.

In two other cells call them, D2 and D4, I take as input the startdate and the enddate.
Now I would like the average in D6.

So the question is what do I write in D6

I hope I gave some clarity to the problem.

Thank you in advance

/KorreSporre