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

show latest date input only
 

Hi

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

Andy.

"Nigel" wrote in message
...
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