Perform statistical calculations to data found in an array

[yayo12]

Hello guys

I was wondering if anyone might be able to help me with the following problem. I have a table that has data by weeks. I want to create a reference that lists each week by month or even quarter and then perform statistical calculations (min, max, median, etc) to the data that meets the time period selected.
For example

[TABLE="width: 500"]
<tbody>[TR]
[TD]7/26[/TD]
[TD]7/19[/TD]
[TD]10/29[/TD]
[TD]10/22[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

I want to create a separate reference list that would look something like
[TABLE="width: 500"]
<tbody>[TR]
[TD]Q3[/TD]
[TD]7/26[/TD]
[/TR]
[TR]
[TD]Q3[/TD]
[TD]7/19[/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD]7/26[/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD]7/19[/TD]
[/TR]
</tbody>[/TABLE]

In theory I would have a custom list where the user can select the desired time period (either a quarter, or a month) and then have the formula take that, look for the corresponding weeks and then perform a calculation. Say for example the median of July, or the sum of Q4

I know it has to be a nested formula, but not sure which operations and in what order to write it so it works.
Thank you