Extraxt highlisst Month

[howard]

I have dates in Col L in format dd/mm/yyy


I am trying to extraxt the highest month in Col L, by using the formula below buy get #value !

=MAX(L:L,MID(L:L,4,2))

It would be appreciated if someone could kindly assist my amending my formula

Excel 2012
	S
35	30/01/2018
36	30/01/2018
37	02/03/2018
38	02/03/2018
Imported Data

 

[sheetspread]

If the dates are numbers:

Excel 2010
	A	B	C
1	Date
2	1/12/2018
3	11/18/2018
4	3/22/2018		11
5	7/6/2018
6	9/4/2018
7	5/7/2018
8	1/24/2018
9	10/21/2018
10	2/28/2018
11	3/20/2018
12	8/4/2018
13	2/1/2018
14	8/16/2018
15	1/9/2018
16	2/27/2018
17	3/19/2018
18	10/1/2018
19	4/18/2018
20	10/27/2018
21	3/8/2018
Sheet5

Cell Formulas
Range	Formula
C4	{=MAX(MONTH($A$2:$A$21))}
Press CTRL+SHIFT+ENTER to enter array formulas.

if text, use the mid function instead of month

 

[howard]

Thanks for the help