Hi Pete

One way
=ADDRESS(49,MATCH(LOOKUP(9.999999E+307,B49:IV49),B 49:IV49,0),1)

In my test I had a date entered in L49 and the formula return $K$49.
It returns one column less, because we are starting from column B, and
not column A. If you wanted column L returned, then put a +1 before the
,1 at the end of the formula.

You said the second to last active cell, in my case there was no data in
I,J or K but L was the last entry in the row that had any value at all.
I'm not certain that this is what you meant, or whether there will
always be contiguous data in the row for you and in which case there
will be a date in K49 for you to use in your calculation.

--
Regards

Roger Govier


"Pete" wrote in message
...
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