show the latest date automaticly

Ok, so I am rusty with excel. I do not know if this is an advanced formula or something I'm simply over looking.

http://i19.photobucket.com/albums/b1...lent/Chart.jpg
This is the picture of the spreadsheet.

I am just trying to make cell C1 show the latest date automaticly. So I do not have to go in and change the formula to the newest date, or just type in the "current score"

Then additionally. I want cell C2 to show the month before thats score.

Please help. my boss wants this in by 4am tommorow.

Thanks in advance,
Justin

Justin

Is this always going to be the result from row 18, or are you going to want to select the residence in column A???


rylo

It will always be row 18. it will just continue to expand down the columns d,e,f,g,h,i >>>>etc...

Hi

Try

C1: =LOOKUP(9.9E+307,18:18)
C2: =INDEX(18:18,0,COUNTA(18:18)-1)


HTH

rylo