=max returning wrong number

[still learning]

I can't get =Max( ...to return the highest number it only returns 2011. If i delete 2011, it returns 2010.
I can't see what's wrong

problem sheet.xlsx
	A	B	C
1	=max(b4:b200) returns
2	2011 when the highest
3	number is 2014
4	4/08/21	2000
5	4/08/21	abc
6	4/09/21	abc
7	4/09/21	2001
8	4/15/21	abc
9	4/17/21	abc
10	4/22/21	abc
11	4/23/21	abc
12	4/23/21	abc
13	4/26/21	abc
14	4/26/21	abc
15	4/26/21	abc
16	4/26/21	abc
17	4/28/21	2002
18	4/29/21	2003
19	4/30/21	abc
20	4/30/21	abc
21	5/02/21	abc
22	5/03/21	abc
23	5/04/21	abc
24	5/05/21	abc
25	5/05/21	abc
26	5/07/21	abc
27	5/07/21	abc
28	5/07/21	abc
29	5/08/21	abc
30	5/10/21	abc
31	5/13/21	abc
32	5/13/21	abc
33	5/13/21	abc
34	5/14/21	abc
35	5/14/21	abc
36	5/17/21	abc
37	5/17/21	abc
38	5/20/21	abc
39	5/24/21	abc
40	5/26/21	abc
41	5/26/21	abc
42	5/26/21	abc
43	5/28/21	abc
44	5/28/21	abc
45	5/29/21	abc
46	5/31/21	abc
47	5/31/21	abc
48	6/01/21	abc
49	6/01/21	2007
50	6/01/21	abc
51	6/01/21	abc
52	6/01/21	1204
53	6/01/21	1205
54	6/03/21	1206
55	6/03/21	abc
56	6/03/21	abc
57	6/03/21	abc
58	6/03/21	abc
59	6/04/21	abc
60	6/04/21	abc
61	6/04/21	abc
62	6/04/21	abc
63	6/04/21	abc
64	6/05/21	abc
65	6/06/21	abc
66	6/06/21	abc
67	6/08/21	abc
68	6/09/21	abc
69	6/11/21	abc
70	6/11/21	abc
71	6/11/21	2008
72	6/13/21	abc
73	6/13/21	abc
74	6/16/21	abc
75	6/18/21	2009
76	6/18/21	abc
77	6/18/21	abc
78	6/19/21	abc
79	6/22/21	abc
80	6/23/21	abc
81	6/23/21	2010
82	6/25/21	abc
83	6/28/21	abc
84	6/28/21	abc
85	6/30/21	abc
86	6/30/21	abc
87	7/01/21	abc
88	7/01/21	2011
89	7/02/21	abc
90	7/05/21	abc
91	7/07/21	abc
92	7/07/21	abc
93	7/08/21	abc
94	7/08/21	abc
95	7/09/21	abc
96	7/12/21	abc
97	7/12/21	abc
98	7/14/21	abc
99	7/25/21	abc
100	7/25/21	abc
101	7/26/21	abc
102	7/26/21	abc
103	7/27/21	abc
104	7/27/21	abc
105	7/28/21	abc
106	7/28/21	1212
107	7/28/21	abc
108	7/29/21	abc
109	8/04/21	abc
110	8/04/21	abc
111	8/04/21	abc
112	8/05/21	abc
113	8/06/21	abc
114	8/09/21	abc
115	8/10/21	abc
116	8/10/21	abc
117	8/10/21	1213
118	8/11/21	abc
119	8/12/21	abc
120	8/13/21	abc
121	8/13/21	abc
122	8/20/21	abc
123	8/27/21	abc
124	8/28/21	abc
125	8/30/21	abc
126	8/30/21	abc
127	8/30/21	abc
128	9/13/21	abc
129	9/15/21	abc
130	9/22/21	abc
131	9/29/21	abc
132	9/29/21	abc
133	9/01/21	abc
134	9/02/21	abc
135	9/02/21	1214
Sheet1

 

[Joe4]

I am not seeing "2014" anywhere in the data you have posted, so it seems to be working properly to me (at least based on the data that you have posted).

 

[RoryA]

I can't see 2014 there anywhere. 2011 is the max.

 

[JEC]

I don't see 2014 in this dataset

 

[still learning]

opps all the 20... are from the wrong account.
I've been looking at it all day.thanks for seeing it so quick
i think i'll take the rest of the week off and reboot my brain


mike