numbers

Created at: 2021-05-30 07:04:10

Questioner General

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) .

Answer #1:

By: Fernando Corwin

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.

SG

Answer #3:

By: Dominic Boehm

You cannot freeze the date.

Answer #4:

By: Mrs. Dovie Hartmann

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.

SG

Answer #5:

By: Ethyl Bruen

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 :)

Answer #6:

By: Tre Ebert

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.

SG