Excel Function for Max Date in a row

Question

A workbook has just over 500 rows and 52 columns.  Column A is an identifier and row 1 is a list of objects.  For each row columns B through AZ is either blank or a date.  For column BA, rows 2 through N, I need a function that will pick out the max date for columns B through AZ for that row (remember, some cells may be blank).  Thanks in advance!!

Answer 1

For row 2:

=MAX(B2:AZ2)  will return the largest date in the row (first instance if repeated)

=MATCH(MAX(B2:AZ2),A2:AZ2,0)  would return the column number where that date was found

combine those into an ADDRESS() function and this formula

=ADDRESS(ROW(),MATCH(MAX(B2:AZ2),A2:AZ2,0))

will return the address of the (first) cell containing the greatest date on the row.

Take that last formula and fill down to get the information for each row.