|If I understand you correctly, this should get you what you want:|
=IF("your calculation"< TODAY(),TODAY(),"your calculation")
However, the TODAY() will update every day to always show the current date, assuming "your calculation" results in a date that is in the past.
In other words, it will not lock in the first date it calculates. It will always display "today's" date.
Is that what you want to see?
One other issue: As explained at the link below, the TODAY() function is "volatile". That means that is will recalculate every time the sheet calculates, even if none of the arguments have changed. A large number of volatile functions can slow a worksheet down.
Volatile and Non-Volatile Functions
Excel supports the concept of a volatile function, that is,
one whose value cannot be assumed to be the same from one
moment to the next even if none of its arguments (if it
takes any) has changed. Excel reevaluates cells that contain
volatile functions, together with all dependents, every time
that it recalculates. For this reason, too much reliance on
volatile functions can make recalculation times slow. Use them
The following Excel functions are volatile:
INFO (depending on its arguments)
CELL (depending on its arguments)
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.