I am using the following formula to show the "today date" if a certain criteria is met.

is there a way of making the date absolute i.e. so that it will not update after the day the calculation was made?

=IF(AND(C12>0,I12=""),TODAY(),"")