View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
Posts: 3,872
Default formula of Inserting a Date in a cell without updating the date


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:

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.

Claus B.
Microsoft 365 for business