Displaying last and recent date

[SpiritedAway]

Column D of my worksheet are dates - 02-Dec-2013 format.
I'm trying to get cell E2 to display the oldest date from Column D & F2 to display the newest date from Column D.

Can anyone advise the function I would need to achieve this.

Any help is much appreciated. I'm using Excel 2007.

[judgeh59]

try this...

E2

Please Login or Register  to view this content.

F2

Please Login or Register  to view this content.

[SpiritedAway]

Brilliant! Thank you.

[judgeh59]

glad I could help and thanks for the Rep points....