RE: Date difference

I think the wrapping is screwy
but try something like
=datevalue(indirect("R"&counta(A1:I1)&"C"&row(),False))-today() for K1
=datevalue(indirect("R"&(counta(A1:I1)-1)&"C"&row(),False))-today() for L1
=datevalue(indirect("R"&(counta(A1:I1)-2)&"C"&row(),False))-today() for M1
just change the counta range to go to other rows..


"Maxi" wrote:

> 2-Dec-04 2-Feb-05 2-Mar-05 15-Mar-05 27-Apr-05 5-May-05 17-May-05
> 6-Jun-05 7-Jun-05
> 4-Jun-04 5-Nov-04 2-Mar-05 2-Mar-05 4-Apr-05
> 2-Oct-04 1-Jan-05 1-Jan-05 2-Jun-05 5-Jun-05 1-Jul-05 1-Jul-05
> 1-Jul-05
>
> I have the above dates in range A1:I3.
>
> I need formula in K1:M3. The answers are in range K1:M3 should be:
>
> 51 52 72
> 115 148 148
> 27 27 27
>
> I want to find out last date in the row and then see its difference
> from today's date (current date per computer time) and put it in cell
> K1
>
> Similarly the second last date difference from current date in L1 and
> third last date difference from current date in M1.
>
> Do the same task for remaining columns.
>
> This is just a sample data I have 3160 rows with 25+ columns
>
> I have entered a formula but I am getting stuck on how to find the last
> date in a row.
>
> Maxi
>
>
.