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