find the second last date in a column

[watonca]

I’m trying to find the second last date in a column.

This comes up with the date

LastCell = Range("A1").End(xlDown).Select

Format(LastCell, "mmm-dd-yyyy") so far so good.

But I can’t seem to stumble onto any syntax that will result in the cell above it.

I have tried things like

Format(LastCell.Offset(0, -1), "mmm-dd-yyyy") but haven’t found it yet.

Suggestions? Please. & Thanks

[Richard Buttrey]

Hi,

One way assuming there's nothing below the last date

Please Login or Register  to view this content.