Retrieving date for last reading in table

[Westbury]

Hi,

I have a tsble of data and am trying to return the date from col C of the last entered reading in col F .

The formula
=ADDRESS(SUMPRODUCT(MAX((F3:F1919<>"")*ROW(F3:F1919))),3)

gives me the cell address $C$1809 which is the correct cell at present.

I've tried wrapping this into =TEXT( ,"D MMM YY") but it still returns the cell address.

What can I do to retrieve the date from C1809?

Thanks
Geoff

 

[Scott T]

Address is returning the address as text, you will need to use indirect to turn it into a cell reference

=TEXT(INDIRECT(ADDRESS(7,19)),"d/m/yy")

 

[Westbury]

Solved! Thank you.

 

[Scott T]

You are welcome.

Just be aware that indirect is a volatile function, it will recalculate any time the sheet is recalculated. If you have a lot of volatile functions the sheet could take some time to recalculate.