Finding average against each row for 7 days by creating a start date and end date |General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi,

This is Shreyas,I am doing a project where I am trying to create a start date and end date in separate columns where when we can choose any date as soon as the start and end date is chose the average values should be shown for a particular sector in a row so basically calculating average for a of a column for a row so that the result should show up when the dates are entered when in range.

EX

Start Date End Date 

       Dates             Row                  Column1 Column2

     5/21/2018        A1

     5/24/2018         A2

The Average of column 1 Against Row and similarly average of column against row and so on.The average calculated value  should show up automatically when the dates are entered

Any kind of suggestions would definitely help me Thanks!