vba code for date matching

Hi,
I have the following dates extracted out to excel from an OLAP database tool.
I have to keep the greatest date value in the subtotals.
How do I compare the date values

01-06-07
15-09-07
27-07-07
15-12-07
15-12-07
15-12-07
15-12-07
15-12-07
15-12-07
15-12-07
15-12-07
15-12-07
15-12-07
06-01-08

Thankyou