Finding Maxium Date in Col E on sheet Dta

[howard]

I have tried to use the following formula to find the maximum date in format mmm-yyyy that is in Col E on sheert 'Data"

I use formatting in Col E as dd/mm/yyyy

Book1
	C	D
1	Jan-1900
Summary

Cell Formulas
Range	Formula
C1	=TEXT(MAX(Data!E:E),"mmm-yyyy")

Book1
	E
2	31/10/2016
3	31/10/2016
4	30/11/2016
5	30/11/2016
6	31/12/2016
7	31/12/2016
8	31/01/2017
9	31/01/2017
Data

It would be appreciated if someone could assist me

 

[jmacleary]

In excel, dates are stored as a number, so all you need to do to find the latest date is use =max(E2:E8) - replace the range E2:E8 as necessary.

 

[howard]

I have tried that and it returns Jan-1900


It should return Sept-2017

Book1
	E
27	30/06/2017
28	30/06/2017
29	31/07/2017
30	31/07/2017
31	31/07/2017
32	31/08/2017
33	31/08/2017
34	31/08/2017
35	30/09/2017
36	30/09/2017
37	30/09/2017
Data

Book1
	C	D
2	Jan-1900
Summary

Cell Formulas
Range	Formula
C2	=MAX(Data!E2:E5000)

 

[jmacleary]

If column E is formatted as text, then this solution will give the result you are getting. Try changing the format of the column.

 

[howard]

Thanks for the advise