Thread
:
Finding the Latest Date from Several Dates in Different Columns
View Single Post
#
4
Posted to microsoft.public.excel.misc
Pete
Posts: n/a
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
Reply With Quote