ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formula of Inserting a Date in a cell without updating the date (https://www.excelbanter.com/excel-discussion-misc-queries/455132-formula-inserting-date-cell-without-updating-date.html)

Rabbi Moshe Hadad

formula of Inserting a Date in a cell without updating the date
 
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.

Any idea?

Thank you

Claus Busch

formula of Inserting a Date in a cell without updating the date
 
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


All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com