=IF(A1=MAX(A1:A100),TODAY(),"")

but this will update tomorrow with the new date, so you will need to do a
copy and pasteValue.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"rtbrd" wrote in message
...
I am tracking a value that will vary by day. I want to record and save
the
date on which the max occurred. Example: If maximum, then record date, if
not maximum leave previous date.

Can I create an If statement that does nothing to the cell if the result
is
false?