fahadshareef
New Member
- Joined
- Dec 25, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I have a worksheet where I track uncleared checks. Whenever I put a R in column I, I want today's date in column O.
I am using formula =IF(I2="r",TODAY(),"") it works but the next day when I open the worksheet the date changes.
How can I lock the date?
I am using formula =IF(I2="r",TODAY(),"") it works but the next day when I open the worksheet the date changes.
How can I lock the date?