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
|