View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default Finding the Latest Date from Several Dates in Different Column

Roger's suggested formula covered the range from A1 to C1, but as you
have three non-adjacent columns you must separate them by a comma and
not a colon. Try this:

=MAX(N2,AP2,AR2)

Pete