View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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