Google Sheets – How to Get the Last Date from a Column on a Different Sheet

google sheets

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:

=FILTER(Sheet1!A:A ; ROW(A:A) =MAX( FILTER(ROW(A:A) ; NOT(ISBLANK(A:A)))))

but this results in an error

Any suggestions?

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

=MAX(ARRAYFORMULA(A2:A))

See example file I've prepared: find maximum date

This formula works perfect:

=IFERROR(INDEX(FILTER(Sheet1!A:A,Sheet1!A:A<>""),
         COUNTA(FILTER(Sheet1!A:A,Sheet1!A:A<>""))))

(found the answer somewhere else)

Use the following formula, to keep track of the notes:

=ARRAYFORMULA(IFERROR(VLOOKUP(A2:A32,Sheet2!A:B,2,0), ""))

If you have more than one note per day, then you can expand the formula to cover more columns:

=ARRAYFORMULA(IFERROR(VLOOKUP(A2:A32,Sheet2!A:B,{2,3,4,5,6},0), ""))