If you want the second but last value and there are no blank cells before
that last cell

=INDEX(A1:A30,COUNTA(A1:A30)-1)


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"t johnson" <t wrote in message
...
am trying to shedule using excel :-)
in row 2 i have used today() then in next column workday(prev colum,1)and
copied this across the length of the row to get my calender
in the following rows i have put the job operations
using formula i want to find the last cell in each row with data and then
if
possible using the offset function get the date my job is predicted to
finish
from row 2 above this last cell in each row Phew!!
hope this makes sense