Find Last cell with Date

  • Thread starter Thread starter Ken Russell
  • Start date Start date
K

Ken Russell

I need to find the last cell in a row that has a date entered. The date
should then be entered into another cell which is updated as more dates are
added to the row.

Thanks for your help.

Ken Russell
Remove hat to reply by e-mail
(e-mail address removed)
 
Hi
for column A try:
=LOOKUP(9.99999999999999E307,A:A)


Note:
- returns the last NUMERIC value. that is you can't differentiate
between numbers and dates (as dates are stored internally as numbers)
- Format the resulting cell as 'date'
 
Back
Top