I have a worksheet with a date column alongside a column with
irregular entries. Some dates have no data alongside.

How do I reference the last cell with data in it?

I hope I have made myself clear!