show latest date input only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top