min and max date in certain quarter

Hi All!

For a sales reporting tool I require to have a minimum date in a quarter and a maximum date in a selected quarter.

In the attachment you'll find a calendar and ive added the expected results.

As our company has a broken fiscal year, different than the one of our supplier, (which are both different to a calendar year) i have created custom columns.

Please have a look and see if you can find me a resolution to find the dates based on the values that will be selected in the dropdowns for "Year" and "Quarter" for CompanyA and for CompanyB.

Thanks a lot in advance!

Well, im anxious, get on with it then.. :P No just kidding!

Thanks for the help so far!

Hopefully someone else finds a way, my thinking was along the line of: IFS, MIN, MAX.
But im unable to produce a formula for it.

Ill have a go with your formula, thank you so far!

Ive tried your formula, but its looking at the when the year starts, it has only one argument.

But it should be on both the YEAR and the Quarter.

So when the year is 2022 and the quarter is 1, then find me the lowest number. and for the last date, the highest number.

When i select Q2, in Column M, the smallest date should be: A122 or 01-05-22

Your help is being appreciated though!

Thanks, this works!
Although im not too sure if i want more columns, my workbook is already around 25MB.

I greatly thank you for your solution, however if anybody else can provide a solution based on the calendar i made without extra columns, i would highly appreciate that.

Shout out to PJ, for being the first!

l12
=MINIFS(A:A,B:B,L5,G:G,RIGHT(M5,1))
m12
=MAXIFS(A:A,B:B,L5,G:G,RIGHT(M5,1))

and similarly for company b but change the columns to H & J

Sorry PJ, but Davsth has captured the recognition kudo's for this one! :P

This is the solution I was searching for, thank you guys for helping me out!