Prev: Progressive Chart
Next: How to remove the cell reference in a sheet at once
From: MD on 24 May 2010 21:00
I need a formula to count the number of days from TODAY() to the last entry
in column "J".
Column "A" is date column.
From: Max on 24 May 2010 21:17
This will grab the date in col A corresponding to the last entry in col J
=LOOKUP(2,1/(J2:J100<>""),A2:A100)

Hence you could use this:
=TODAY()-LOOKUP(2,1/(J2:J100<>""),A2:A100)

Adapt the ranges to suit
--
Max
Singapore
---
"MD" wrote:
> I need a formula to count the number of days from TODAY() to the last entry
> in column "J". Column "A" is date column
From: MD on 24 May 2010 21:39
Many thanks Max that works ok

"Max" wrote:

> This will grab the date in col A corresponding to the last entry in col J
> =LOOKUP(2,1/(J2:J100<>""),A2:A100)
>
> Hence you could use this:
> =TODAY()-LOOKUP(2,1/(J2:J100<>""),A2:A100)
>
> Adapt the ranges to suit
> --
> Max
> Singapore
> ---
> "MD" wrote:
> > I need a formula to count the number of days from TODAY() to the last entry
> > in column "J". Column "A" is date column
 | 
Pages: 1
Prev: Progressive Chart
Next: How to remove the cell reference in a sheet at once