| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lock in current date
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! |
|
#2
|
|||
|
|||
|
One way
http://www.mcgimpsey.com/excel/timestamp.html Regards, Peo Sjoblom "Angus" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| How can I lock a date that has been established by the 'today ()'. | Excel Discussion (Misc queries) | |||
| How do I stop today() from updating date on saved spreadsheets? | Excel Discussion (Misc queries) | |||
| How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) | |||
Linear Mode
