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 ChartNext: How to remove the cell reference in a sheet at once