I have a spreadsheet which contains a list of songs and the dates that they are used.
I would like to be able to have a cell at the beginning of the list of dates, which simply displays the last date the particular song is used.

I have been unable to find a formula function which will do this, which does not mean that it doesn't exist.

So, to reduce the question : I need a formula which will find the last, non blank cell in a given row or range of cells.

In addition, there can exist cells which are blank between filled in rows.