MAXIF on dates

[RFurball]

I searched through the many MAXIF posts and can not find a solution to my problem. Lets say I have a two column list, first column is date and second column is quantity. What I am looking for if the maximum value from a particular year.

I tried =MAX(IF(YEAR(A2:A12)=2017,B2:B12)) but it returns zero. I think the YEAR(A2:A12) is not valid for a logical compare. Any help on this formula would be appreciated.

My data might look like this:
Year Quantity
04/01/17 9.0
05/25/17 3.0
08/15/17 7.0 Year Max
02/01/18 2.0 2018 0
03/15/18 4.0
05/15/18 5.0
09/06/18 6.0
12/15/18 2.0
01/15/19 9.0
02/15/19 3.0
03/12/19 4.0

and when I enter a year I wan the max to be found in column B for that year.

 

[JoeMo]

Excel Workbook
	A	B	C	D
1	Year	Quantity
2	4/1/2017	9
3	5/25/2017	3
4	8/15/2017	7	Year	Max
5	2/1/2018	2	2018	6
6	3/15/2018	4
7	5/15/2018	5
8	9/6/2018	6
9	12/15/2018	2
10	1/15/2019	9
11	2/15/2019	3
12	3/12/2019	4
Sheet1

 

[RFurball]

Thanks that works, I have used CTRL SHIFT ENTER before but I forgot what it did. I thought I used it to sum across worksheets or something like that.