I want to write a function which returns the last date a student attendend
class.
Working from column IV backwards it would be the first cell in each row with
hours recorded.
The spreadsheet is setup like the following:
X Y Z
.........IV
29 Dates= 7/1 7/3 7/8
: LastDate*
33 Name1 7/3 3.2 2.5
34 Name2 7/8 1.5 4.5


Some tried to suggest to me using =INDIRECT(CHAR(LastDate(Row())+#)&"1"),
but it doesn't work.

Thanks in advance your help.
-Stacy