Count number of days from the last entry?

  • Thread starter Thread starter MD
  • Start date Start date
M

MD

I need a formula to count the number of days from TODAY() to the last entry
in column "J".
Column "A" is date column.
 
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
 
Many thanks Max that works ok

Max said:
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
Click to expand...
 
Back
Top