Populate Latest Date From A Range

Hi,

What formula can I use to populate the latest date from a range ? Example , lets say I have a range of date from March 23 2008 to April 28 2008.

I need a formula to check from this range and populate April 28 2008 as the latest date.

Is there a formula that I could use for this purpose ?

Thanks in advance.

As long as they are "actual" dates, and not text formatted cells, you can use the MAX worksheet function. For example, if the dates are in the range A1:A100, use:

=MAX(A1:A100)

HTH

Jason

Thank you .That worked ! Appreciate your time and patience.