How to find latest month in Excel formula

[Shan54321]

Hi ,

I have below with three different months sometimes same months in excel and i want to find which is the latest month in a separate column . Any formula can suggest .


d/m/y d/m/y d/m/y d/m/y
1/5/2017 1/8/2017 1/9/2017 1/9/2017

Latest Month ???

[Fluff13]

If your values are real dates & in separate cells, you can use MAX like

Please Login or Register  to view this content.

[Shan54321]

Thanks a lot

[Fluff13]

You're welcome