Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm looking for help on the following:

How do I get the last date from a column in sheet1 returned in a cell of sheet2

I tried it with:


but this results in an error

Any suggestions?

share|improve this question
What kind of error? Could you share the spreadsheet with us? – Vidar S. Ramdal Mar 2 '13 at 11:58
up vote 2 down vote accepted

The following formula will find the maximum date in column A:


See example file I've prepared: find maximum date

share|improve this answer
Thank you, you´re my hero ! :-) – ibitom Mar 2 '13 at 14:50
It works like a charm. Do you have an idea what I can do if the collumn doesn´t contain dates, but text ? – ibitom Mar 2 '13 at 14:52
That indeed is another question. Please read this section of the faq how to deal with answered questions. – Jacob Jan Tuinstra Mar 2 '13 at 19:28
You´re right. I have posted a new question. Thanks. – ibitom Mar 3 '13 at 8:02
@JacobJanTuinstra, you might want to change the "share" permissions on the example you've prepared. – Xavier Casto Jul 1 '13 at 23:19

To find the last value entered in col A (of sheet1), also try


and see if that works ?

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.