Maximum and Minimum Date within a specific year.

[JohnZ1156]

I have a column (range) of dates. I would like a formula to tell me the minimum date within a year and the maximum date within a year.

Example:

 

[JamesCanale]

MrExcelPlayground19.xlsx
	A	B	C	D
1	10/28/2023
2	11/22/2023		Year	2024
3	12/17/2023
4	1/11/2024		Min	1/11/2024
5	2/5/2024
6	12/26/2024		Max	12/26/2024
7	1/20/2025
8	2/14/2025
9	3/11/2025
Sheet15

Cell Formulas
Range	Formula
D4	D4	=MIN(FILTER(A1:A9,YEAR(A1:A9)=D2))
D6	D6	=MAX(FILTER(A1:A9,YEAR(A1:A9)=D2))

 

[JohnZ1156]

Hi JamesCanale,

I see how your formula works. Thank you
But now, I would like it to return the value of the "nth" cell to the right.

For example:
Min 1/11/2024 1,234.00

 

[JamesCanale]

Not sure I get you:

MrExcelPlayground19.xlsx
	A	B	C	D	E
1	Date	Thing 1	Thing 2	…	Thing N
2	10/28/2023	235	735	984	372
3	11/22/2023	592	814	525	796
4	12/17/2023	573	210	882	132
5	1/11/2024	828	899	876	872
6	2/5/2024	858	458	569	703
7	12/26/2024	101	846	141	607
8	1/20/2025	909	105	561	576
9	2/14/2025	822	217	629	402
10	3/11/2025	882	640	636	422
11
12
13
14			Year	2024
15			Thing Column	4
16
17			Min	1/11/2024	872
18
19			Max	12/26/2024	607
Sheet15

Cell Formulas
Range	Formula
D17	D17	=MIN(FILTER(A2:A10,YEAR(A2:A10)=D14))
E17	E17	=VLOOKUP(D17,A2:E10,D15+1,FALSE)
D19	D19	=MAX(FILTER(A2:A10,YEAR(A2:A10)=D14))
E19	E19	=VLOOKUP(D19,A2:E10,D15+1,FALSE)

 

[JohnZ1156]

Thank you, Sorry I wasn't completely clear from the beginning.
I thought, once I got the first answer, I would be able to figure out the rest.
I was wrong.

Thanks again.