Hi,

Am Wed, 5 May 2021 03:03:34 -0700 (PDT) schrieb Rabbi Moshe Hadad:

I want to add a Date in a cell based on another cell,
For example:
=if(D2="","Empty",TODAY()),

But i don't want that "Today" will be update. It just need to stamp the Today date without keep updating.

that is not possibe with a formula.
You must write the date with the shortcut or with VBA.


Regards
Claus B.
--
Windows10
Microsoft 365 for business