Lock in current date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help please. I have a worksheet where data is entered in a number of cells.
I want another sheet to display the date the data was entered in a
corresponding cell and to be blank when nothing is entered. I can get the
blanks to work OK and I can get the current date with this formula -
=IF('worksheet 1'!B4="","",TODAY()) - The problem is that the date changes
every day. How can I write this formula to keep the date the same regardless
of what day it is? Thanks in advance for any assistance!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
If cell is blank automatically enter today's date in the same cell 21
Excel Vba to change displayed year automatically. 14
Use first day of month formula in a drop down list 3
Working with Dates 4
Current date 2
Excel How to get the number of days an item was opened from the today's date. 14
Paste Values in linked Cells Only 4

Back
Top