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?