show latest date input only

Hi,

i have a range in a sheet1 (E3:E60). i have a cell on my Summary page that
needs to show the latest date inputted into this column only. for example

E3
12/10/05
13/10/05
17/11/05
21/11/05
1/12/05

the cell in the Summary sheet should read 1/12/05 and update if i put
another later date inot the column on sheet1.


thanks,


Nigel

Hi

Try using the MAX function:
=MAX(E3:E60)

Andy.

"Nigel" <Nigel@discussions.microsoft.com> wrote in message
news:7C66D562-CD85-4765-BF6F-17C20EBA2593@microsoft.com...
> Hi,
>
> i have a range in a sheet1 (E3:E60). i have a cell on my Summary page that
> needs to show the latest date inputted into this column only. for example
>
> E3
> 12/10/05
> 13/10/05
> 17/11/05
> 21/11/05
> 1/12/05
>
> the cell in the Summary sheet should read 1/12/05 and update if i put
> another later date inot the column on sheet1.
>
>
> thanks,
>
>
> Nigel
>