Hi there. Could you please help me create a formula that would return a date when two cells are equal to each other.
The point is that the date does not update when the mold is reopened.
I think sth like this but how to freeze the date? =if (A1=B1;TODAY;0) .
You can't freeze the date via formula. But once the date is recorded via the formula you can manually remove the formula itself and leave the date by selecting the cell, command-c to copy, Edit > Paste Formula Results.
You cannot freeze the date.
Tak, to wiem, ale ta operacja zajmuje tyle samo czasu albo więcej niż wklepanie daty " z ręki". Ale dzięki za zainteresowanie :) Pozdrawiam :)
Don't think that's entirely true. Command-c followed by Edit > Paste Formula Results (or shift-command-v) is very fast if the date has already been entered by the formula.