The max for that row?

If yes:

=index($c$3:$l$3,match(max(c4:l4),c4:l4,0))

if your dates were in C3:L3 and your values to check were in C4:L4



Gary''s Student wrote:

Consider using:

=HLOOKUP()
--
Gary''s Student
gsnu200709

"Holke" wrote:

I keep weekly values of my investments in a row and then search with the max
function. How can I return the date (row 3 of the colum that max value is
in) that the max value occured?

--

Dave Peterson