Find latest date for each row
 

How can I create a function that will find the latest date for each row of
data in a spreadsheet?

I have about 10 columns that hold dates, I need to check them and "pull" the
latest date into a new column. The issue is that the date fields are not
right after each other.

I may have 6 dates in a row and then then other 4 are about 5 columns
further down the row

Find latest date for each row
 

=max(A1:L1)
will return the largest date in A1:L1

(format it as a date if you need to)

scuba79 wrote:

How can I create a function that will find the latest date for each row of
data in a spreadsheet?

I have about 10 columns that hold dates, I need to check them and "pull" the
latest date into a new column. The issue is that the date fields are not
right after each other.

I may have 6 dates in a row and then then other 4 are about 5 columns
further down the row

--

Dave Peterson