Assuming no embedded blanks between B49 and the last cell then:

=INDIRECT("B"&COUNTA(B49:B1000)+47)

will return contents of last but one cell in column B. Change upper limit of
B to suit.

Does that help?

"Pete" wrote:

I'm Looking for a formula that will allow me to select a starting cell (B49),
then find and select the second to last active cell in that row. I have a
living spread sheet that grows and shrinks based on user input and want a
formula to calculate the days between the start (B49) and finish (B???).

Can anyone help??
--
Pete