Maximum and minimum values for last quarter

[ice_28]

Every business day I enter a date and a corresponding numeric value.
When I enter the first entry of a new quarter, that should be a trigger to calculate the maximum value of the previous quarter, the minimum value of the previous quarter and the last value of the previous quarter.
Each quarter does not have the same number of days/entries – they vary. Quarters go as follows: 1 Jan-31 March (Q1), 1 Apr – 30 Jun (Q2), 1 Jul – 30 Sep (Q3), 1 Oct -31 Dec (Q4).
Can you please help me calculate the maximum, minimum and last price of the previous quarter – without a VBA code? Instead, I’d prefer using formulas and functions.

 

[WinteE]

Is there any data that marks a new quarter, a date for example ?

 

[ice_28]

Is there any data that marks a new quarter, a date for example ?

Yes, there is a quarter number in each row.

Column A = date
Column B=prices
Column C= calculates the quarter number based on the date in column A
Column D - I need to calculate the maximum value of all prices in the prevous quarter.
Column E= I need to calculate the minimum value of all prices in the prevous quarter.

The problem is, quarters can have different number of days, so we can't use a constant range.

I have a simple example of the data in Excel, but can't figure out how to attach a file here.

 

[ice_28]

Thank you all. The problem has been solved