Averaging a user input defined range based on values in columns

I am wanting to determine values such as Min, Max, Average, Ect. of a user inputted range.

Column A
Day
1-Jan
2-Jan
3-Jan
4-Jan
5-Jan
6-Jan

Column B
Average
7.5
8.4
6.3
7.9
6.9
6.8

Column C
Average High
16.5
18.1
18.3
17.2
16.7
15.8

Column D
Average Low
-3.3
-3.6
-6.6
-4.0
-3.8
-4.4

These values are a 365 day summary of various temperatures. I have saved each 365-cell column into "Weather_Day", "Weather_Average_Temp", "Weather_Average_HTemp", "Weather_Average_LTemp"

The idea is to allow for the following input:

Start Date: "User Input"
End Date: "User Input"

After the user inputs the two dates, I want to return the max, ave, min, ect based on that range. i.e.

Start Date: 1-Jan
End Date: 3-Jan

These inputs would then average (7.5, 8.4, 6.3) and return 7.4 to a pre-determined cell.

I able able to index, match, sumproduct to locate specific values but can't get a "range" to automatically update based on user inputs.

Suggestions?

Thanks!

I and other members cannot view pictures so it is always preferably to upload a real workbooks instead of pictures.
maybe you could work with the formulas below.

=AVERAGE(IF($A$1:$A$10>=ref for start date),IF($A$1:$A$10<=ref for end date,$B$1:$B$10))) -> ctrl + shift + enter not just enter

for higher version which i think you don't have prior to your profile but just in case.
=AVERAGEIFS(Sheet2!B:B,Sheet2!A:A,"<="&C3,Sheet2!A:A,">"&C4)
C3 =start date
C4 =end date

ethan.xlsxlook at this with two options given in #2 post

Your Welcome. Glad to help.
You can mark this thread "Solved" if you have time.
Tip:
To Mark Solved.
How?
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.

just change the average with min or max

=MIN(IF((A1:A50>=I1)*(A1:A50<=I3),B1:B50)) -> ctrl+ shift + enter not just enter same with the max()