Edit: Split from [Solved] Insert today's date as a static date since this is a new problem by a new person in a solved topic. |
Code: Select all
=IF(A1="";"";IF(B1="";TODAY();B1))
When the sheet is opened the first time the date is displayed correctly like "12-06-03", and the doc is saved
When we re-open the document instead of seeing the date like "12-06-03", we see the formula as in the attached screen shot
Tools -> Options -> Iterations box is checked, Steps is set to 1
oo ver 4.1.7