Find latest date

The answer I require is probably very simple but I have puzzled over this
for days.

I am using Excel97 and have a spreadsheet in which I have a column of dates
formatted as dd-mmm-yyyy which have been gathered from other sheets in the
workbook.

What I require is a formula to select and display at the bottom of the
column the latest date.

Thanks in advance.

John

=MAX(A1:A1000)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"john.bedford3" <[email protected]> wrote in message
news:[email protected]...
> The answer I require is probably very simple but I have puzzled over this
> for days.
>
> I am using Excel97 and have a spreadsheet in which I have a column of
dates
> formatted as dd-mmm-yyyy which have been gathered from other sheets in the
> workbook.
>
> What I require is a formula to select and display at the bottom of the
> column the latest date.
>
> Thanks in advance.
>
> John
>
>

Thanks Bob

Its so simple when you know how.

Your help is much appreciated.

John

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> =MAX(A1:A1000)
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "john.bedford3" <[email protected]> wrote in message
> news:[email protected]...
> > The answer I require is probably very simple but I have puzzled over
this
> > for days.
> >
> > I am using Excel97 and have a spreadsheet in which I have a column of
> dates
> > formatted as dd-mmm-yyyy which have been gathered from other sheets in
the
> > workbook.
> >
> > What I require is a formula to select and display at the bottom of the
> > column the latest date.
> >
> > Thanks in advance.
> >
> > John
> >
> >
>
>