canarycat123
New Member
- Joined
- Sep 1, 2021
- Messages
- 27
- Office Version
- 365
- 2019
- Platform
- Windows
Hello everyone,
I'm using the below formula to populate a cell with today's date when the adjacent cell contains data.
=IF(ISBLANK(B164)," ",NOW())
Can anyone confirm how to adapt this formula so that upon entry of the date is becomes 'locked', meaning that when the sheet is opened the following day (or any other day in the future), it does not change to that days date?
I'm using the below formula to populate a cell with today's date when the adjacent cell contains data.
=IF(ISBLANK(B164)," ",NOW())
Can anyone confirm how to adapt this formula so that upon entry of the date is becomes 'locked', meaning that when the sheet is opened the following day (or any other day in the future), it does not change to that days date?